Forum Discussion
Solved
Excel formula
Hi All, Query 1- I need a formula where if I change the value in a cell the value of the other cell should change Eg - If I change the value of cell 1 to 6 PM then the cell 2 value should chang...
AQureshi1709 See attached file for solutions to both queries.
AQureshi1709 See attached file for solutions to both queries.
Riny_van_Eekelen Thank you soo much!!!
The only issue I am facing is that my Data i.e Day, Night, 6 PM & 8 AM is on different sheet2 of the same file.
PFA, added sheet 2 on the same file.
AQureshi1709 See attached. I chose to use named ranges for the two relevant areas. Then it doesn't matter where in the workbook they are.
Riny_van_Eekelen This is Great!!! Looks way easier than the last formula we used. But I am unable to implement on my original sheet
- I did it!!!!!!!!!!!! Thanks a bunch, Sir!!!!