How do I get Column C to automatically calc which is the latest date per item?
Latest Date.xlsx
Thanks
How do I get Column C to automatically calc which is the latest date per item?
Latest Date.xlsx
Thanks
In C2: =IF(B2=MAX(IF($A$2:$A$9=A2,$B$2:$B$9)),"Yes","")
Confirmed with Ctrl+Shift+Enter as it's an array formula and filled down.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Or if the data is always sorted as it is in the sample just =IF(A2<>A3,"Yes","") in C2 copied down.
Dom
Thanks! All sorted
Crikey I used the array formula on a 11,000 row sheet and it put our server too 100% for about an hour!
Is there a less cpu intensive way of doing this?
Thanks
Aye, sort the data and use my second suggestion.
Dom
Hi
Give a try to this.
=IF(LOOKUP(9E+99+307,SEARCH(A4,$A$2:$A$9),$B$2:$B$9)=B4,"Yes","")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
How does that work fotis?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks