Forum

Hi Moavu, Slicers sort in alphabetical order. If you want to override that you can use a custom list to enforce your own sort order. I explain how ...

Hi Andrew, Yes, a table will automatically expand the conditional formatting as the table expands. You have to be careful that you don't paste your...

Hi, Add the date to the text string to create a unique text string that is date specific: =IF(D2<0,-D2&"-"&COUNTIF(D$2:D2,D2)&A2,...

It would help if you upload a sample file so we can see your question in context.

Good point, Dugald. I didn't notice the slight difference in date formats but I figured he'd build the text string using a combination of the text for...

Hi Divisha, Excel automatically does this. The best option is to format the numbers as text by putting an apostrophe in front of them. e.g. '09 ...

Hi Steve, You need to use the INDIRECT function to resolve the address: =VLOOKUP(B3,INDIRECT("'I:AccountingFinance Statements PlantFY 2016"&...

Will do, Darko.

I'm not sure which part of the formula you want updated, the table_array or the row_index_num? If it's the row_index_num then you can use the ROW o...

Hi Bert, I don't think there's a command that exists for that, but you could record your own Macro and then assign it to an icon in your QAT. My...

I presume you mean you want to evenly distribute the data across all pages when printing data that exceeds one page worth. That's a good question. I d...

Hi David, You can either record a macro that applies that formatting and then assign it to a button on the QAT (Quick Access Toolbar) or a shortcut...

Unfortunately this is a known bug in PivotCharts. You could try saving your formatting etc. as a Chart Template and then apply the template again e...

Thanks for dropping by and saying hello! Hope to see you again soon 🙂

Power Query is the new tool for cleaning data. Much better than a VBA approach IMO.