Forum Discussion
JTrehus
Feb 02, 2022Copper Contributor
Excel formula - Show value in dedicated cell based on various values in multiple cells.
Hi, I would like to get some help with finding a correct formula for the following cases. Case #1 If text in A3 shows 'Monday' i would like to get the autosum of D3-C3 visible at E3. ...
- Feb 03, 2022
See the attached sample workbook. I used a list of public holidays in The Netherlands; you can edit the list as needed.
HansVogelaar
Feb 03, 2022MVP
See the attached sample workbook. I used a list of public holidays in The Netherlands; you can edit the list as needed.
JTrehus
Feb 03, 2022Copper Contributor
Hi Hans,
Thank you again (Hartelijk bedankt),
This is a amazing setup with formula's i never could figure out myself....
Thanks again for the quick and helpful support.
Have a nice day.
Jeroen
Thank you again (Hartelijk bedankt),
This is a amazing setup with formula's i never could figure out myself....
Thanks again for the quick and helpful support.
Have a nice day.
Jeroen