Excel Logic, Who Will Solve This Problem Please?

I've read this a dozen times and have no idea what you are trying to do, nor why you have this table arranged this way. I don't know what 'raw b' is.

Maybe you should google what you want, such as 'sort data in Excel'.

https://support.office.com/en-in/article/Sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654

Think he means:

Find max. value in column A, (i.e. in cell A3) and copy to C1

Copy corresponding time from column B (i.e. cell B3) to D1

(For "raw" read "row"!).

Am I right in thinking what you want to do is find the maximum value of column A and display that in column C, then you want to display the value from column B which correlates to the maximum value in column A in column D?

Fardan
Your question makes absolutely no sense and is likely a homework question?
Please re-state your question because it seems like you are trying to do something that does not compute?

??????????????????????????????????????????????????????????????????????????????

Sorry, I forgot the cell numbering.

However I'm still trying to figure out what you want. I will look at it in a bit.

Sorry about my language

A & B are given, in C column, it is the max value of A column where I use =MAX(A1:A3), but in D I want to copy the corresponding time row of that max value.

Or you can say I want to reach following logic:

if Ci = Ai so Di=Bi, where i= 1,2,3 ....etc.

example:

If C=300, then D= 4:00am.

Here I know that I can use max(A1:A3) for C column, what should I use for D column?

Sorry again for my language.

I'm pretty sure I've already shown you how to do that. Type earlier reply in to a cell in column D. It worked with numbers, no reason to think it won't for dates.

Use the vertical lookup in Cell D1. =VLOOKUP(C1,A1:B3,2)

this looks for the value in C1. WHERE C1 IS =MAX(A1:A3)

and returns the value in the second column (2) in the array (A1:b3).

This assumes the values in column A are in order.

read the help file for using the lookup functions for additional uses.

The VLOOKUP function needs to be completed.

The equation in cell E2 should read: =VLOOKUP(C1,A1:B3,2,TRUE)

This will solve the problem.

Test this solution by changing any of the values in Column B (100, 200, etc.) to the max value and check the result.

This answer is correct if sequenced or not sequenced.

TRUE is not a required argument for the Range_lookup in the VLOOKUP function. If you want to find an exact match, FALSE would be required. This function still won't work if the dataset has duplicates. in the first column.

Norm

It will return the first MAX value (sequenced or not), which is still correct.

=VLOOKUP(C1,A1:B8,2,TRUE)

I had to change your indices just slightly. That sort of works until one starts changing all the values in the "A" column. There is something not right about using VLOOKUP without sorting the lead column as the instructions explicitly state. Sorting the data table will fix this formula, but it also is allowing approximate match (not OK most of the time), change "TRUE" to 0 for exact match.

VLOOKUP(C1,A1:B8,2,0) using this formula, no sorting of the data table is necessary. It only outputs an exact match.

nvirciglio and Maca,
Thank you,
Yes this is if it is in order, what if it is not in order? I mean A; B; C and D are always in same Rows but not sequenced (i.e. row 1, then row 45, then row 75..etc)

AB are same rows but not sequenced, CD as well but CD are not same rows as AB!

Fardan: First of all - a row is horizontal, and a column is vertical. That might help you get sorted out.

Using the formula that Maca suggested will work as well.

Yes but this is if A ordered sequentially, A:A, I need to fined other way if A is not ordered, A1 jump to A15, between A1 and A15 not included. Is there any solution?

With respect, it is difficult to find a logical solution for the analysis of data which has not been entered logically. Your first task is to design a data entry system which ensures that all data ends up in a single table without any gaps. It may be that your initial data entry system leaves gaps, but then the first part of your data analysis routine must be to ensure that there is a data transfer to an intermediate single table with no gaps, on which the final processing is performed. Posts #4 and #9 then offer you entirely workable answers.

Try filling in the empty cells in col. A with zeros.

One always has the option of applying data sorting before undertaking the application of the statistical logic function on the data. You have the answers before you, go forth and prosper.

It is OK, as long as you reference all the data in table in your indirect(match) or vlookup. The rows that are left blank calculate as 0 in the formula for the maximum.

Don't be scared just do it. If you are worried about duplicates, then you should include another function in another row that counts up the duplicates, but how to find the time for the 1st, 2nd, 3rd,... duplicates might be cumbersome.

There is a guy, Mr. Excel, who lives, I think, in Uniontown, OH. He has written quite a few books on Excel, and has another in progress on Tips. One of his books should help.

I have no idea myself, but once you find the Max A, is it possible to increment that cell address to get the time?