I have an appointment book which auto fills from another sheet but I need to create a client tracker so that the date and time are listed next to the client,
Please see the attached workbook
Any help would be appreciated,
JD
I have an appointment book which auto fills from another sheet but I need to create a client tracker so that the date and time are listed next to the client,
Please see the attached workbook
Any help would be appreciated,
JD
In F2 Cell - Array Formula
Formula:Please Login or Register to view this content.
In G2 Cell - Normal Formula
Formula:Please Login or Register to view this content.
In H2 Cell - Array Formula
Formula:Please Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Drag the formula's down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks