advanced formula help

Hi there, I was given the task to force balance the data in 'Q1_2024_Raw' to sum to the final total by GEO (i.e. all LATAM customers need to sum to 10, so in this case I need to force balance their data down from 20 to 10 and all NAAM customers need to sum to 100 so I need to force balance up...

I'm trying to create a formula that produces a certain value based on a list of options. Essentially, I want to know whether a someone associated with a city should be placed in "Zone 1", "Zone 2", or "Zone 3". "Zone 1" and "Zone 2" have a set of values associated with them, and then "Zone 3"...

Hi All, I am a novice when it comes to excel coding. I work in a advertising/sales company as a graphic designer and the previous owner of the company created multiple excel documents so we could send out artwork proof forms to clients. One of the forms he created so we could print to pdf and...

Would love some advice on this! I'm honestly not sure if it's possible. It feels like it *should* be. In one sheet, I have a list of products, each with varying release months. Adjacent to the launch month, I have plotted the succeeding two months to create a 3 month total "New Release Period"...