Excel-getting the extreme values of a data group
Hi
I am sorry, I have to re-open this query.
Actually I have tried to reply to an earlier response for this query but as I am unable to attach the spread sheet there, sending this as a new topic again.
Please let me know how to attach a file in the reply window.
The idea of inserting a Pivot Table and there by getting Min & Max is good but this works for numeric fields only, I believe.
The format of document numbers in my spread sheet is like this:1234_0456.0789.tif and I should not change them in any manner.
They are arranged in increasing order.
Every day, I am happening to filter on each operator and get their From tif & Thru tif numbers.
Please find the appended sheet and review the report (placed in sheet-2) that I need to generate on a daily basis based on the data present in sheet-1.
Please suggest me the best practice, so I can avoid manual extraction of From tif & Thru tif numbers and save my time.
Thanks & Regards
Kumar.
| Attachment | Size |
|---|---|
| Allotment.xlsx | 10.02 KB |
Hi Sorry, I could not
Hi
Sorry, I could not respond to your solution as my system has crashed.
I tried putting the above functions in the spread sheet, but they are not working.
Could you please suggest me a way.
Regards
Kumar.
translation
So:
EXTRAE it's MID
CONCATENAR it's CONCATENATE
VALOR it's VALUE
BUSCARV it's VLOOKUP
if you give your e-mail adress i can send you a file with my solution.
Regards,
emma
Sure, here it
Sure, here it is
nivas.avvaru@gmail.com
Please send me the sheet with solution.
Good to learn some translation of Spanish words to English along with Excel teachings.
Thank you for quick response and your great support.
Regards
Kumar.
done
please, tell me if it works!!
Wov! I have downloaded the
Wov!
I have downloaded the sheet & found its working. It is Absolutely fantastic.
Thank you so much for providing the solution sheet.
Great support.
Regards
Kumar.