Related Posts
my help this am
Which agency does the HCP promo for Lynparza?
Additional Posts in Excel Genius
I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?
What are the most typical models you all build
New to Fishbowl?
unlock all discussions on Fishbowl.
Use the small function to identify rank order of net sales. then based off of net sales use index match to pull in sku
Note that, on top of the small function, you can also use the top/bottom conditional formatting rule if you want to present the data nicely too
Why not just throw into a dB and just SQL query
Yeah the tie is an issue - there’s a way around it but it’s kind of janky. You can create a helper column that does rank + countif(net sales range up to current cell, =current row net sales)*a tiny factor (smaller than whatever the net sales is significant to. So if net sales goes to two decimal places, multiply by like .0001. It will fix the issue because it makes the duplicate values unique
Was just ranking in and then having a list of 1-10,000 and index matching the values, but the ties throw it off. Need it to be automated and beginning to think VBA is only hope
You can sort them greatest to least then it would be easier to identify bottom 5%