Related Posts
Chief
Conversation Starter
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
Anyone know what these badges are?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Respectfully, what?
ChatGPT?
Is it not just a series of sumifs and dividing by a unique cell or the total in that month? Seems like the simplest way to do it, you just need to set up the data correctly.
I.e. one criteria is for the colour of the widget, one criteria is the month, etc. all divided by the total widgets in the month?
It does seem like a basic formula question but until you can adequately describe what you’re trying to do, we can’t really help much.
Coach
Let me rephrase your question back to you to make sure I understand: you have a spreadsheet with transactional date such as: (total of 4 red widgets)
2023-02-20 | Red widget | QTY 1
2023-02-01 | Red widget | QTY 2
2023-02-05 | Blue widget | QTY 1
2023-02-07 | Red widget | QTY 1
Then you want to be able to input:
Month: 02
Widget: Red
QTY: 1
And received the following output:
25%
Is that right?
Coach
So you want to enter a number of red widgets in a cell, then you want the number you just entered to be overwritten with a percentage on that same cell? I don’t have all the details about your use case but this doesn’t seem very practical. If you insist on having this done then you can do it with VBA.
Dynamic functions, potentially with filter, sort, or create your lambda function.
Chatgpt will sometimes give you oldest excel functions, it will still insist on using vlookups over xlookups unless you tell it to use certain functions.
Also depends on what version excel you have.
Potentially create a prompt and be very descriptive on What your output needs to be with the prompt scenarios before you go straight to VBA