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
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