 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Ok, this is baking my noodle (I'm at work and your answer could make me look like a superstar)
In column B I have a number - say 1000
In column A I have a place name - say London
now column B has 4 instances of the number matching to 4 different place names:
Column A Column B
London 1000
York 1000
Glasgow 1000
Edinburgh 1000
So what I'm looking to do is when column B shows the same number 4 times, drop/delete the first 3 rows so I'd only be left with cell A4
Any ideas?
Edit - the formatting didn't quite work
Simplest is to have a formula in column C (or in colA in another worksheet if necc) such as: =IF(B1<>B2, A1, "")
and then in D, say,: =IF(C1<>"", B1, "")
this requires that all your incidences of "1000" (or "2500" etc) are grouped though
then copy and paste value the resulting columns and use data sort to crunch it all together.
I'd only add that this isn't IT dudes you need help from. Try the sales/project management/accountant dudes instead.
Yeah, IT dudes arent very much good at useful stuff 😉
ok, slight edit i think
If column B shows the same number 4 times, drop/delete the first 3 rows so I'd only be left with cell A4 and B4
so the first 3 lines may show different places and the same number, if the number appears 3 times it only leaves the fourth line and deletes the other 3
Youd need to use VBA to "delete" lines, hence using the "" method to hide the three lines and keave the last of four. then sort to get rid of the blanks.
or email it to me and Ill send it back in a few minutes for you.
Email sent Stoner, many thanks
and you go calling yourself dogbert?