Can anyone help with this sample data problem?

Jimmy110

Board Regular
Joined
Feb 28, 2022
Messages
63
Office Version
  1. 365
Platform
  1. Windows
I'm wanting to know how to report a figure from one column, when the data changes in another....So my example is in column A I have a list of jobs that change every so often (in the first case its the same from row 2 to row 27, then changes at row 28) what do I need to do to report the value in cell D28 when it sees a change in column A?

Any help is really appreciated

Link to file Example Data.xlsx

Cheers

James
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
What exactly do you mean by "report the value"?
 
Upvote 0
What exactly do you mean by "report the value"?
Basically, I want it to look down Column A and when it sees a change report the value in the same row in column D. So in this example file, I would like it to show somewhere the value of D28, D37, D60, D123, D148 & D154.

So it would look like this:

00:13:16
00:06:33
00:05:22
00:14:57
00:36:01
00:03:39

or even better if if showed the job name from Column A, like this:

597814 PLAIN WR MINI - 70x200 (15KG) 00:13:16
St James Samosa Med 00:06:33
St James Samosa Large 00:05:22
597865 PAPRIKA FATTAYER 90MM ROUND (15KG) 00:14:57
597806 FATTAYER 90mm ROUND (15KG) 00:36:01
599599 SEED SAMOSA - 180 x 62 15KG 00:03:39

Basically, it would show me how long in time it took to change from one job to the next.

Hope that makes sense?

cheers
 
Upvote 0
Upvote 0
Ok, another option
Example Data.xlsx
HI
1
2
3597806 FATTAYER 90mm ROUND (15KG)00:00:00
4597814 PLAIN WR MINI - 70x200 (15KG)00:13:16
5St James Samosa Med00:06:33
6St James Samosa Large00:05:22
7597865 PAPRIKA FATTAYER 90MM ROUND (15KG)00:14:57
8599599 SEED SAMOSA - 180 x 62 15KG00:03:39
Sheet1
Cell Formulas
RangeFormula
H3:H8H3=UNIQUE(A2:A157)
I3:I8I3=INDEX(D2:D200,XMATCH(H3#,A2:A200,0,1))
Dynamic array formulas.
 
Upvote 0
Solution
Wow....I'm impressed peeps.... thank you so so much!!!!!!! I really appreciate it.
 
Upvote 0
Glad we could help & thanks for the feedback.
 
Upvote 0
One more option :

Example Data.xlsx
FG
1JobTime Interval
2597806 FATTAYER 90mm ROUND (15KG)00:00:00
3597814 PLAIN WR MINI - 70x200 (15KG)00:13:16
4St James Samosa Med00:06:33
5St James Samosa Large00:05:22
6597865 PAPRIKA FATTAYER 90MM ROUND (15KG)00:14:57
7599599 SEED SAMOSA - 180 x 62 15KG00:03:39
Sheet1
Cell Formulas
RangeFormula
F2:F7F2=UNIQUE(A2:A157)
G2:G7G2=VLOOKUP(F2#,$A$2:$D$157,4,FALSE)
Dynamic array formulas.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top