-
If you would like to post, please check out the MrExcel Message Board FAQ and register here.
If you forgot your password, you can reset your password.
lax
-
R
macro to copy out rows that have a start date, end date, and days of week into separate days
Hi Everyone, New to this as a member but have referenced mrexcel.com for years. Great site and resource! I'm trying to create a macro that will copy out rows of data based on a start date, end date, and days of week into individuals single dates. I've found ways to break out the date range...- richardsonyyc
- Thread
- 73h 73w date las lax
- Replies: 1
- Forum: Excel Questions
-
E
SUMIFS with multiple criteria in different rows
Hi everyone, Apologies I seem to be stuck on what I thought would be a simple formula. I have a large dataset of customers taking flights (one ways in the dataset) and I am trying to calculate how many are 'most likely' round trip flights (matching by customer name then origin to destination...- eldeartho
- Thread
- 14/03/2018 atl jack jfk lax
- Replies: 3
- Forum: Excel Questions
-
J
Create a rank based on three fields in Excel
<tbody> YEAR CLIENT STATION STATIONCNT STATIONCNT RANK 2019 A CHI 8 1 2019 A LAX 2 2 2018 A DAL 7 3 2018 A SFA 25 1 2018 A NYO 8 2 2018 B SFA 1 4 2018 B CHO 10 1 2018 B CHI 4 2 2019 B LAO 2 3 2019 B LAX 23 1...- janetk411
- Thread
- chi lax rank stationcnt year
- Replies: 9
- Forum: Excel Questions
-
W
Duplicate List items based on varying quantities?
I'm having some issues figuring out if you can create a dynamic list of values in a range, based on separate quantities per item. I have seen it done via VBA, but I'm trying to avoid that if I can. This is an example of the Data:- Code Qty 1 Lax 3 2 SF 1 3 Tan 2 4...- Wolfspyda
- Thread
- based duplicate lax list tan
- Replies: 12
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
VBA to find values in several columns, based on common value in a different column, then copy paste to different sheet
- Started by mlepesant
- Replies: 26
Hello, New to the forum. Good excel skills but almost no VBA experience. I have a file that provides me with Bill of material for different... -
if cell has a value then copy and paste whats in that cell and to the right of it
- Started by drop05
- Replies: 25
Hello, a bit new to this. 1. Using VBA im trying to see if there is a way to check if a cell has a value, in my case cell G52, if it has a value... -
force drop-down list only when 1 of 6 possible answers in a different cell is met.
- Started by CaptainChaos
- Replies: 23
I have done some reading on dependent drop down lists, but everything I have found refers to when there are for example 2 or more choices in 1... -
Transfer table filtered data to new worksheet in respective column, 2nd tab data transferred under last row in respective columns.
- Started by Dave01
- Replies: 23
[URL unfurl="true"]https://www.dropbox.com/scl/fi/4mp0zl1gu1fiizp6dhse6/test-macro.xlsm?dl=0&rlkey=ejd7qgpi7mcg0cfjb6u6qkcdi[/URL] Hi The link... -
Error with Loop
- Started by Jeeremy7
- Replies: 22
Hello, I have a problem with one of the loop I'm trying to do and I think it's in the formula but could somoene help me ? Also I saw that some... -
VBA date in local format
- Started by opislak
- Replies: 21
Hello all, As a European, my keyboard layout is set by default to show dates with '-' as in 11-06-2021 or jun-21 I would like to modify the '-'...
