PDA

View Full Version : Need help on how to get previous matching row data!!



JackkG
02-10-2015, 03:54 PM
Hi all,

I need to find the author name where its frequency=1, but want to copy the data only if the previous author name is same. Say for instance author name is Alex on row 5 and its frequency is 1, but want to check for if the previous row, i.e., row 4 also contains the author name Alex. If yes i want to copy row 4 and 5 to the result sheet.

Any help on this? the sample sheet is attached for better understanding.

Thanks!!

JG

Cross Posted Here:
http://www.excelforum.com/excel-programming-vba-macros/1065942-need-help-on-how-to-get-previous-matching-row-data.html#post3985199

http://www.mrexcel.com/forum/excel-questions/835107-need-help-how-get-previous-matching-row-data.html#post4071303