Formula Help

excelbrands

New Member
Joined
Jun 25, 2020
Messages
1
Office Version
365
Platform
Windows
I am trying to compare dates between 2 different worksheets in the same workbook and summarize differences on summary worksheet. First I would need to search by ID number to make sure I am looking for the correct line, than look at the close date, compare this to the other worksheet using same ID number and see if the date changed. If it did, by how much? If no change than don't include in summary. I know there are a lot of steps and watched a ton of videos and am so confused. See attached
 

Attachments

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,582
Office Version
365
Platform
Windows
If your ver. of 365 has the FILTER function then try:

Summary Sheet
Book1
ABCD
1IDAcctClose DateReg
212545Comcast3/25/2019E
312546Vitafusion2/19/2019W
412547Shutterfly2/20/2019C
512548Stitch Fix1/15/2019E
Summary
Cell Formulas
RangeFormula
A2A2=SORT(FILTER('Quarter 1'!$A$2:$D$6,'Quarter 1'!$C$2:$C$6<>'Quarter 2'!$C$2:$C$6))


Quarter 1
Book1
ABCD
1IDAcctClose DateReg
212545Comcast3/25/2019E
312546Vitafusion2/19/2019W
412547Shutterfly2/20/2019C
512548Stitch Fix1/15/2019E
612549Apple2/1/2019W
Quarter 1


Quarter 2
Book1
ABCD
1IDAcctClose DateReg
212547Shutterfly5/25/2019C
312546Vitafusion4/3/2019W
412548Stitch Fix6/25/2019E
512545Comcast4/5/2019E
612549Apple2/1/2019W
Quarter 2
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,930
Messages
5,508,176
Members
408,669
Latest member
AgsikapAko

This Week's Hot Topics

Top