Dear all,
In my attached payroll file I need to filter "Bank" and "Cash" in column C.
The serial number in first column is continually for both Bank & Salary.
But when I filter salary - "Cash" or "Bank" in column C, I need the serial number in A column in Sequence.
What will be the formula should I place in A column, so that the serial no in Column A shall be sequence
even if I filter "Cash" or "Bank" in C column.
Please anyone can help me out from it?
Regards
ebincharles
Bookmarks