Question description:
This user has given permission to use the problem statement for this
blog.
Hello ..!!!! i have Question regarding Excel Index & match Function.
Solved by O. C. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
11/05/2018 - 10:18
Welcome, Thanks for choosing Got It Pro-Excel.
User
11/05/2018 - 10:18
i have question regarding exce index & match function'
Excelchat Expert
11/05/2018 - 10:19
Okay.
Excelchat Expert
11/05/2018 - 10:19
What is the question please?
User
11/05/2018 - 10:21
i want to display the Price of the same item but at different occassions the Price was different
User
11/05/2018 - 10:22
how can do this using index & Match Function..?
User
11/05/2018 - 10:24
Out Put i want to be as er the table indicated
Excelchat Expert
11/05/2018 - 10:24
Okay. I have seen it.
Excelchat Expert
11/05/2018 - 10:24
Let me figure this out.
User
11/05/2018 - 10:25
but this table is small , so i could do it manually , but i have some huge table where i need formula to help me #
User
11/05/2018 - 10:25
thanks
Excelchat Expert
11/05/2018 - 10:27
Okay.
User
11/05/2018 - 10:34
any update..?
Excelchat Expert
11/05/2018 - 10:36
Almost please.
User
11/05/2018 - 10:36
thanks
Excelchat Expert
11/05/2018 - 10:53
The first formula is to return a list of unique Item names.
Excelchat Expert
11/05/2018 - 10:54
The formula is;
Excelchat Expert
11/05/2018 - 10:54
=INDEX($A$3:$A$13,MATCH(0,COUNTIF($D$7:D7,$A$3:$A$13),0))
User
11/05/2018 - 10:54
noted
Excelchat Expert
11/05/2018 - 10:55
Once we have the unique items list, will use it to find the different corresponding price values and put them in a row.
User
11/05/2018 - 10:55
can i have the formula for that..?
Excelchat Expert
11/05/2018 - 10:56
Just a moment as I tweak it please...
Excelchat Expert
11/05/2018 - 11:17
Thank you for your patience.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
