SpreadEveryone: The Fetchland Excel wire
1 lurker |
101 watchers
Oct 2022
11:36am, 12 Oct 2022
38,502 posts
|
SPR
To be clear, the max cost day in the month. Yes multiple days could have the same cost.
|
Oct 2022
12:23pm, 12 Oct 2022
5,201 posts
|
run free
SPR - can you use PowerPivot? Bring the data into PowerPivot and use the CALCULATE function. I will have a look in the evening after work to see if you've managed to sort it out. The calculation should be faster and you can use all 40K rows from your data |
Oct 2022
12:52pm, 12 Oct 2022
1,830 posts
|
Bowman 🇸🇪
Anyone good with Excel VBA? I have done a few things, but now i'm stuck for hours with probable a simple thing for a pro? Its a script i want to run in Outlook, since outlook rules cannot move emails according to file attachment names. But i'm stuck. |
Oct 2022
1:13pm, 12 Oct 2022
6,602 posts
|
um
Still missing it SPR. Why can't you flag multiple package rows as Oct and then pick the max? Bowman - this looks to be a macro you could tweak to test for specific content? techniclee.wordpress.com |
|
Oct 2022
1:34pm, 12 Oct 2022
38,505 posts
|
SPR
Um - Let's use different words. Clients have multiple line items, a package is all the line items open at any one time. Therefore all line items open at a point in Oct are only part of the package on a day in Oct if they were open on that specific day. A package is multiple line items, if it wasn't I wouldn't need a sumifs inside a max, it would be a simple maxifs. run free AFAIK power pivot doesn't use the same formulas so it doesn't seem all that simple without having time to investigate the possibilities in power pivot. |
|
Oct 2022
1:47pm, 12 Oct 2022
6,606 posts
|
um
If you need to track it and then sum it by day, I'd still be tempted to build an array with a column per day populated with the rate per day if the contract/package is active. Then it's still a simple add and max, rather than 40k (or however many) iterations of multiple index commands. |
|
Oct 2022
2:06pm, 12 Oct 2022
38,506 posts
|
SPR
There isn't 40k index commands, the index is in the summary per client. I don't see how having 365 columns to represent each day in the year is a good way to do it and probably won't be any quicker given it would be 365 * 40,000 and then I'd still need to find the day with the max cost across the multiple lines. The current summary is 13,000 * 12 for the formula that gives me the result I need. |
|
Oct 2022
2:19pm, 12 Oct 2022
1,831 posts
|
Bowman 🇸🇪
UM, that one might work, i have another one, a little more complex. But the one you linked, its depending on making a rule triggering that macro, and that function is removed due to security reasons since a while. Tts possible to change the register, but that involve my IT department at work, so i will try not to go that way. The issue i now have is that my code doesn't seem to find the "to" folder, and i just cant see why. Everything else seems to work. Besides a little unsure of when its triggered. i used this: datanumen.com And here are some problems that i have. forums.slipstick.com |
|
Oct 2022
2:29pm, 12 Oct 2022
6,607 posts
|
um
Bowman - are your folders sub folders of inbox, or peer level folders? Your code (I think) looks like it's trying to move to a subfolder. Is that what you intended? (noting this is the first time I've read or seen outlook refs in VBA) |
|
Oct 2022
2:32pm, 12 Oct 2022
1,832 posts
|
Bowman 🇸🇪
Its a subfolder of a folder in the inbox: Inbox/Outlookdata/callsdaily |
Related Threads
-
Excel skills test
Mar 2019
-
Accounting Question
Oct 2017
-
Important excel files deleted - Please Help
Oct 2016
-
download training log to excel
Jan 2024
-
Excel boffins - your needed!
Sep 2018
-
World Cup sweepstake in excel
May 2018
-
HELP! Excel file corrupted and I need it!
Aug 2016
-
Running Club Spreadsheet to track PBs
Apr 2014
-
The Retirement Thread
Jan 2025
-
Any pension experts out there?
Oct 2024
