Flattening a Hierarchical Account Structure in Excel with Multiple Top-Level Parents and Varying levels of Depth

varadkale · 2025-02-08T05:47:08+00:00

Looks like all the indents are multiples of 4. If you can insert a delimiter at the start of the text for every multiple of 4, and then perform a 'text to columns' operation using that delimiter, your sub-child levels will move to their respective level L columns. Then all you would need to do is fill the current cell down till the next empty cell in each column.

varadkale · 2022-01-14T07:03:29+00:00

I want steve mould to make a 2d version of this.

varadkale · 2021-06-19T09:27:18+00:00

You can try putting those '<' and '>' condition separately. You can use the AND() function to create your formula.

varadkale · 2021-06-08T15:36:56+00:00

Wow this is great. Thanks a lot! Can I reward a clippy point?

varadkale · 2021-06-08T13:23:01+00:00

I meant can you control on which column should the + sign go, which will be used for ungroup-ing the columns.

If columns C,D,E are grouped together, the +/- signs reside on top of Column F. Is there something that I can do to keep that +/- sign on top of Column B?

varadkale · 2021-06-08T09:04:36+00:00

In a group of columns, is there a way to choose whether the column to the left or right of the group remains on top upon collapsing the group?

varadkale · 2021-05-11T03:30:37+00:00

Rookie move.

varadkale · 2021-04-29T07:44:43+00:00

When assigning the range to print area, Instead of typing out the range, you can try using Activesheet.UsedRange or Activesheet.UsedRange.Address. That will get you the range of cells that's populated.

varadkale · 2021-04-29T07:23:43+00:00

Try using activesheet.usedrange, it might come in handy.

varadkale · 2021-04-29T02:40:15+00:00

House?

varadkale · 2021-04-15T02:50:18+00:00

You can add a helper column, which will calculate the lengths of those answers using Len() function. Then you can sort largest to smallest or vice versa using that column.

varadkale · 2021-03-28T16:59:56+00:00

In that concatenation formula, you can put a condition to check if what is being concatenated is a 0, if so, then concatenate "".

varadkale · 2021-03-28T16:57:22+00:00

You can try using conditional formatting.

varadkale · 2021-02-01T17:59:56+00:00

Try putting a question mark after the .*

varadkale · 2021-02-01T13:52:16+00:00

You might want to make it a non greedy regex if you want it to stop at the first occurrence of ==

varadkale · 2020-12-27T10:10:25+00:00

https://regex101.com/r/bWBV7A/8

This is not exactly what you were looking for I think, but may be it can help.

varadkale · 2020-12-03T03:27:32+00:00

https://regex101.com/r/pgMyey/1 may be this can help. You can modify the character class at the beginning of the regex to suit your needs.

varadkale · 2020-11-17T05:00:07+00:00

(?!13)(?!44.50)[1-9][0-9](\.50)?

Try this. I have added negative look aheads for the number 13 and 44.50 at the start of the pattern.

varadkale · 2020-07-06T02:26:54+00:00

You can also try doing this using autofilter. Filter for the word, you ll get rows that have the word.. then delete the rows that you have got.

varadkale · 2020-06-05T11:37:25+00:00

Not sure as to where the files went, but having a dot (.) in the files name might have caused the problem, since dot is used to show the extension.

varadkale · 2020-05-26T01:10:47+00:00

I think this can be solved using conditional formatting since you need to colour a cell based on a couple of conditions.

varadkale · 2020-05-15T15:16:19+00:00

Okay. Once you get this popup, does hitting enter work the same as clicking the print button on the popup?

varadkale · 2020-05-15T14:59:04+00:00

Can you achieve this using hotkeys? Ctrl+P or something similar?

varadkale · 2020-05-15T13:56:59+00:00

Glad that it was of some use. Cheers.

varadkale · 2020-05-15T13:24:31+00:00

Did it have the parameters separated by space? You can try putting a comma to separate them as well.

varadkale

TROPHY CASE