Forum

In B1, enter =INT((A1-1)/8)+1 or =INT((ROW()-1)/8)+1 and copy it down. Have added these to your file, plus one extra in case the sequence ...

Please see attached. I've applied a technique to your file as described in Mynda's blog Note that I had to fill in some data in the Status...

I'm afraid not. Excel formulas can not manipulate column width. But there are ways to present the data you want with formulas that extract/filter the ...

It wasn't all that difficult, though I needed to create some sample data tables that weren't linked to your system. I limited the example to Worker ID...

Well, start by sharing some data (remove anything confidential). Perhaps it just a small issue that can be resolved easily.

Hi Sherry, I see you persist in using LET with a FILTER and an IF, although it serves no purpose. Best to focus on using FILTER alone. Your CHOO...

Thay would be: =LET( f, FILTER( CHOOSECOLS(tbl_UPDATED, {2,1,5,3,4,6,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26...

I would create a function that picks-up the available page from the PDF. Begin with finding out how many pages your PDF has and create a table in E...

Cross-posted with a solution.

Looking at your file, it seems that Department 1, for instance, only has data for three Business Units (BU). Calculated items are applied to all De...

There's no file attached. Please try again and don't forget to press "Start upload" before you submit your reply.

This works on 365 but not on 2019. With regard to the number 192282800044, I noticed that all your 'numbers' in column A are in fact texts, except ...

Great! Though v2308 is rather old. I'd recommend to update first. From the file I noticed that you have used pre-365 array formulas entered with Ct...

Sure, it's as safe to upload as last time. If it contains confidential information I'll send you a mail (if you don't mind) to which you can respond. ...

Could you upload a file demonstration your issue please? And which Excel version are you using?