WS attached-Please help
There Are 3 headings on both sheets named “LEAD” and “LG” that are the same and
where the following info will need to go; headings are “APPT”, “TAKEN” and “SOLD”.
When any date is entered into “LEADS” H6:H1005, that date will be counted as “1” and entered
Into “LG” I22:I1021 only when the dates from “LG” B22:B1021 and “LEADS” B6:B1005 match exactly.
I need the same formula for the adjacent headings on the “LEADS” sheet under TAKEN and SOLD.
Thank you
Enter below formula in cell I22 on sheet LG and copy it to J22 and K22.
Then copy the 3 formulas down to row 1021.
Formula:
Please Login or Register to view this content.
See attachment.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
works great! thanks so much
Glad I could help. Thx for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks