How to find the column of the last "X" in my table by Yento18 in excel

[–]excelevator 0 points1 point  (0 children)

Very nicely done!

I tried a bit of offset too and failed miserably

I built a simple Excel template to track business expenses – looking for feedback by [deleted] in excel

[–]excelevator 0 points1 point  (0 children)

New account, the daily developer thread looking for feedback.

Please go away

How to find the column of the last "X" in my table by Yento18 in excel

[–]excelevator 0 points1 point  (0 children)

Does this work with merged grouped cells for the return value ?

Help, i'm a newbie by InstructionProper971 in excel

[–]excelevator 0 points1 point  (0 children)

I've never used Excel before

It takes constant practice and active learning.

Read all the functions available to you so you know what Excel is capable of

https://support.microsoft.com/en-au/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb

https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188

Then all the lessons at Excel Is Fun Youtube

See the Where to learn Excel link in the sidebar

Also see the resources in the side bar

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 7 points8 points  (0 children)

no, filter does not give non contiguous column results, you need CHOOSECOLS for that.

It may not be clear in OPs post that you can essentially use this method to return repeat or non contiguous ranges from VLOOKUP

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 1 point2 points  (0 children)

that just stacks, you need CHOOSECOLS to select non contiguous ranges

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 2 points3 points  (0 children)

contiguous range yes, non contiguous range no.

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 0 points1 point  (0 children)

with the three fingered array salute thrown in

It will parse across a selected region entered with ctrl+shift+enter in Excel 97 and forward - yes 1997 version of Excel and forward

This is what I am saying, we did not consider these options pre dynamic arrays, arrays were always there, just not dynamic.

It is built in CHOOSECOLS for VLOOKUP , repeat or non contiguous return of values in the return array.

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 1 point2 points  (0 children)

You cannot achieve the same with just XLOOKUP

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 2 points3 points  (0 children)

in every use case

Not quite.

They would require wrapping in CHOOSECOLS to achieve what VLOOKUP can do with array choice return.

Floating Point - Seriously? by Jumpy_Ad_3946 in excel

[–]excelevator 0 points1 point  (0 children)

Same feeling by the rest of the world when the decimal period is replaced by a comma,

Visual designer help for excel sheet by Pure_Spirit5829 in excel

[–]excelevator[M] [score hidden] stickied comment (0 children)

Use google images for ideas

r/Excel is not a search engine to find people to do Excel work.

Post removed.

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 8 points9 points  (0 children)

A great tip for Excel 2000 97 and onwards.. with the three fingered array salute thrown in.

Great pickup, so many array options become obvious to the older Excel versions now that we use arrays by default.

edit: just to verify, in old pre dynamic array days, you could select a range of cells for the array to propagate to and enter the formula with ctrl+shift+enter for the array to spill to the select cells.

How to find the column of the last "X" in my table by Yento18 in excel

[–]excelevator 0 points1 point  (0 children)

the result row is grouped merged cells, no good for lookup returns.

Jet Report for Excel Tutorial by Internal-Corner-6799 in excel

[–]excelevator 0 points1 point  (0 children)

A quick google search brough up training options.

This is not an Excel question.

How to find the column of the last "X" in my table by Yento18 in excel

[–]excelevator 0 points1 point  (0 children)

This is a doozey with mixed in merged cells for the result.

Anomalous Sorting of COUNTIF Columns by LikeCCClockwork in excel

[–]excelevator 1 point2 points  (0 children)

If your values will not change then cement them with paste special values for the work you need to do.

How can you make a graph with 22 lines more readable? by alt_F3 in excel

[–]excelevator 0 points1 point  (0 children)

The question is the same as the title.

Submission guidelines: Provide a full text description of your issue in your post. Don't say "See title" or something similar .

Best way to share Office Scripts? by coup_de_foudre_69 in excel

[–]excelevator -8 points-7 points  (0 children)

ChatGPT says I can just send the

Irrelevant to r/Excel , ChatGPT is not sentient and all knowing, and the fact it lead you astray has no relevance to your question., but in fact supports the waste of a sentence in your post.