paramveer Member Feb 15, 2019 #1 my question in excel sheet. please suggest me what to do Attachments question 1.xlsx 11.1 KB · Views: 6
V vletm Excel Ninja Feb 16, 2019 #2 paramveer 1) do filter [ Equals TOTAL ] with A-column 2) do filter [ Less Than 100 ] with B-column 3) modify the highest 'TOTAL' as needed 4) copy previous cell 5) select other 'TOTAL'-cells 6) do paste 7) clear filters
paramveer 1) do filter [ Equals TOTAL ] with A-column 2) do filter [ Less Than 100 ] with B-column 3) modify the highest 'TOTAL' as needed 4) copy previous cell 5) select other 'TOTAL'-cells 6) do paste 7) clear filters