Hello.
I have an excel spreadsheet with two tabs. The first tab, called MASTER, has a census of employee data included in it.
I need a formula that will either look in column A and return in sequential order, the information contained in all other columns for every row where Column A's value is a whole number (no decimal point), or look in column B and return in sequential order, the information contained in all other columns for every row where Column B's value is "E".
Attached is a sample spreadsheet. I need the appropriate formula to go in the second tab called Formula Sheet.
NOTE: I have a third tab in the attached sample worksheet which shows what the results should look like on the Formula Sheet once the formulas are inserted into the respective cells.
Thank you so much in advance!
Bookmarks