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...
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...
<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...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.