Hi
I have some data that I ranked and am trying to only show a certain portion of the data in a different location.
In the data I have a certain item I do not want to show in the end result, say "bananas". This week "bananas" are ranked #4. I have tried using a IF and Offset formula that would look at the item and if it was a match would go down one row.
=IF(AD28="Bananas",OFFSET(AC28,1,0),AC28)
Once it finds "bananas" it will show the #5 and then will show #5 again in the next field. In other words it does skip #4 but shows the next rank twice.
If bananas in list skip and show next ranking item.
The list updated every week any the rank is volatile.
Thanks in advance for your help!
I have some data that I ranked and am trying to only show a certain portion of the data in a different location.
In the data I have a certain item I do not want to show in the end result, say "bananas". This week "bananas" are ranked #4. I have tried using a IF and Offset formula that would look at the item and if it was a match would go down one row.
=IF(AD28="Bananas",OFFSET(AC28,1,0),AC28)
Once it finds "bananas" it will show the #5 and then will show #5 again in the next field. In other words it does skip #4 but shows the next rank twice.
If bananas in list skip and show next ranking item.
The list updated every week any the rank is volatile.
Thanks in advance for your help!