Forum Discussion
Excel Formula Question
Can someone help. I'm trying to figure out how to count how many days between a certain number was used. Example the number 3 was used on December 1st, 2019 and again on March 12, 2020. I'm trying...
Subodh_Tiwari_sktneer I appreciate the help. I'm still having issues. I tried to modify the formula you sent me to see if I could get it to work, but to no avail it isn't. I'm attaching what I'm working on if you don't mind giving me some pointers I would greatly appreciate. I'm also putting the formula I tried to make here. Thank you again.
=IF(COUNTIF($B$3:$E$542):(B3:E542)B4:E4)=1,"",A3-MAX(INDEX((B$2:E$542,:B2=B3)*(A$3:A3),)))
Can you rephrase your requirement and explain what exactly you are trying to achieve considering the sample data? And can you please upload the sample data file along with the desired output mocked up manually for few rows explaining the logic behind that output on the sheet itself.