Formula needed

Question

New here looking for some help.&nbsp; Trying to filter out information in 2 separate columns.&nbsp; I want just the Name in column A and the total amount in column C.&nbsp; This is an example of what I have:&nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CFULL NAME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EMPLOYEE NUMBERSmith, John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;62835Cochair Activities&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PAY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17,432&nbsp;I *ONLY* want to see the name and the number 17,432.&nbsp; I want to apply this to an entire sheet.&nbsp; Many thanks in advance?&nbsp;

harun24hr · Answer

Can you post few more sample data. Put a screenshot so that we can understand how your data are placed in cells. Also it would be better if you share a sample file via onedrive or google-drive.

Forum Discussion

Formula needed

1 Reply