Please see the attached file. I want to perform percentage calculation through VBA. The results should be what is given in G column. This is an example workbook. If I do it through macro recording, it only applies for the current range.
Please see the attached file. I want to perform percentage calculation through VBA. The results should be what is given in G column. This is an example workbook. If I do it through macro recording, it only applies for the current range.
Hi,
array formula (Ctrl+Shift+Enter) in a cell 'G4' and a copy down
=IFERROR(F4/INDEX($F$1:$F$1500,MIN(IFERROR(IF(SEARCH("Total",$E4:$E$1500),ROW($F4:$F$1500),""),""))),"")
Regards.
Last edited by maras_mak; 09-05-2018 at 03:23 PM. Reason: Formula repair
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks