How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Mark W Your Own Question
Mark W
Mark W, Consultant
Category: Programming
Satisfied Customers: 44
Experience:  BSc in Computer Science
106604827
Type Your Programming Question Here...
Mark W is online now

I have a question in excel. I know what I want but I wanna

This answer was rated:

I have a question in excel.
I know what I want but I wanna make to process automated as I have got a very large data
can you please help me?
firest I want where the name is ***** ***** the time to be the same, then combine them. in the attached file I have done an exaple of what I reakky wantMaryam

Hi there,

Have you tried using the Remove Duplicates button from the Excel Data tab?

Regards

Customer: replied 7 months ago.
no I have not, I don't wanna lose the data. I need the total for further analysis

Will copying the column into another column work and then removing duplicates? You'll still have the full data in the original column then.

Customer: replied 7 months ago.
but will not match with the rows
Customer: replied 7 months ago.
I need the second column to be a foreign key and the third to be a primary key in my GIS analysis.

If you use the following formula, it will remove the duplicates (i.e. if row above is the same, show blank)

=IF(A2=A1,"",A2)

Customer: replied 7 months ago.
this is for the final step would helpbut what about the time
I just want to make where it is duplicate
minutes to be equal
Customer: replied 7 months ago.
can you please check the 2nd column, and how I can do that automatically?

If you sort column A by time, and then use the above formula, it will get rid of the duplicate times.

Customer: replied 7 months ago.
sorry I think you got me wrong
I want to keep the time first I need itI want my second column to contain the information as the attached image

Ok, but what logic do you want for the 2nd column? If next row in column in A is only one minute less round up?

Customer: replied 7 months ago.
if the sum is equal to 5 minutes
Customer: replied 7 months ago.
check this case in the attached photo

Umm. So you don't just want to round up to the nearest 5 minutes, e.g. 9:48, 9:49 to 9:50 and 9:51, 9:52 to 9:55?

Customer: replied 7 months ago.
Customer: replied 7 months ago.
like where the data and geocode and name is ***** ***** the time equal too with regards ***** ***** first reading
Customer: replied 7 months ago.
date*
Customer: replied 7 months ago.
Is there is a way to do that?

I'm still not completely clear on the logic. E.g. why wouldn't B18 be 12:23 since it is within 5 mins?

Customer: replied 7 months ago.
sorry, my bad. because I have done it manually I made a mistake
it actually must be 12.23
Customer: replied 7 months ago.
is that what you mean?

Exactly

Customer: replied 7 months ago.
I am sorry about that.

Is this what you want? See attachment

Mark W and 5 other Programming Specialists are ready to help you
Customer: replied 7 months ago.
indeed thank you so much, you are amazing.
thanks for your time

Thank you. For any new questions feel free to ask away at https://www.justanswer.com/computer/expert-markw/

Regards

Mark