removign duplicates based on date #

[Faisalomran1]

here is the input that I have

Job Start Date	well API Number	number of fracturing job opearations on the well	Total Base Water Volume (gallon)
1/9/2018	1107200500001	2	31710
3/13/2018	1107200500001	2	59678
12/18/2014	1107203940000	2	93326
2/18/2015	1107203940000	2	93238
1/16/2015	1107204000000	2	96432
2/22/2016	1107204000000	2	42000
5/29/2015	1107204150000	2	47124
2/8/2016	1107204150000	2	50000
4/12/2013	3023106750000	2	8555904
4/15/2013	3023106750000	2	8737134

what i am trying to output is this

Job Start Date	well API Number	number of fracturing job opearations on the well	Total Base Water Volume (gallon)
3/13/2018	1107200500001	2	59678
2/18/2015	1107203940000	2	93238
2/22/2016	1107204000000	2	42000
2/22/2016	1107204000000	2	42000
4/15/2013	3023106750000	2	8737134

in order to do this I need the software to include ( well API number) that appears in the second date and exclude the first appearance.

thank you.

[bpatel · Accepted solution]

hi @Faisalomran1 ,

Is this what you are looking for?

hope this helps

[Faisalomran1]

that is helpful. thank you

I just have one problem some ( well api numbers) appears three times and I want to include only the second appearance. how can i do this.

[bpatel]

hi @Faisalomran1 ,

Sure. Here is one approach that will always pick the second instance.

[Faisalomran1]

3/2/2016	4030566080000	3
3/28/2016	4030566080000	3
4/4/2016	4030566080000	3

thank you so much, I just have another question.

so in the table above how cam I add a column to report the number of appearance as shown below

3/2/2016	4030566080000	3	1
3/28/2016	4030566080000	3	2
4/4/2016	4030566080000	3	3