Looks good. If you don't want to have a value of 0 when there is no data you can change your formula in H1 to:
PHP Code:=IF(INDEX(D2343,$E$3,0)=0,"No Data",INDEX(D2343,$E$3,0))
Looks good. If you don't want to have a value of 0 when there is no data you can change your formula in H1 to:
PHP Code:=IF(INDEX(D2343,$E$3,0)=0,"No Data",INDEX(D2343,$E$3,0))
Last edited by Aussiebear; 04-29-2023 at 07:23 PM. Reason: Adjusted the code tags
Posting Permissions
Reply With Quote