Search results

Hi. Posting a sheet with would be helpful ( no pics please)

Apply the filter then use the Go To command and select Special and on the right select Visible cells only. You can then apply your colour once you take the filter off you will see it has applied this to only the filtered rows you had filtered.

Could you please post a sample of your csv sheet?

Manually adding some expected results would help..

This being said, there is a saying in French : " Le diable est dans les détails"

Thanks. I know how it works. VSTACK/HSTACK seem to be the only ones added to the older functions. Good to know

@p45cal Didn't know that VSTACK accepted 3D-References. Good to know. Would you have a link to a complete set of these functions, I can't seem to find an updated one. Thx

Looks contradictory to me, as asking for an XL version is already a waste of time... This being said, is it so difficult to add an Excel version option to a profile ? Every forum I am on offers the possibility except here I would not bet a penny on that, considering that on most forums OP's...

Any success, Luke? Does it mean this site is " dead"?

Tried to import with Power Query, here is what it returns... Strange

I can't see what's wrong? First start date is 4/12/23 and end date in 2024, so OK All other start and end dates are in 2024 but your dates in row 7 are ALL in 2023, so no CF to be applied

Wouldn't this be easier using MsWord?

Hi please post a sample sheet (no pics please) with some data . Which XL version are you using?

@Shabbo And FYI, without manual alignment text is left aligned in cell, numbers are right-aligned. At a glance you can see what is wrong (BTW Ali's nickname might be " EagleEye Ali " :)) So, avoid applying manual alignment before you are satisfied with you formulas

Try =SUMPRODUCT(--((MOD(COLUMN(E3:AH3);2)=1)),(E3:AH3))-((COLUMNS(E:AH)-2*COUNTIF(E3:AH3,""))*8/48) ( your expected result in row 4 does not seem correct)

With today's tools that should not be a problem anymore. I've been on forums for years and never heard of it. But you did not say if your answers are obtained with AI or not? ( and I'm not the only one to thinks so)

We seem to be having a member ( @Monty ) making heavy use of AI, without letting us know :(

Hi. What is your XL version? In recent versions the TEXTJOIN function is a possibility

Right click your cell - Format Cells - Number Tab - Select Custom - Type: scroll down to and select [h]:mm:ss - OK If you don't need the seconds just enter manually [h]:mm in the Type bar (BTW using merged cells for your dates is a bad idea and will get you into trouble for further analysis)...

Sheet provided by @Juniad is not protected in any way

This is the code let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Custom1 = Table.FromList(List.Transform(Source[Date],Splitter.SplitTextByDelimiter("#(lf)")), Splitter.SplitByNothing(), {"Date"}, null, ExtraValues.Error), ExpandedDate =...

It's always best (especially with date/time problems) to post an excel sheet, not a picture. Thx

I don't get the logic, sorry.

Posting a sheet instead of a picture, with some expected results would really help

Using XLOOKUP =XLOOKUP(1,($I$3:$I$6=$A3)*($J$3:$J$6=$B3),$K$3:$K$6)*($D3/SUMPRODUCT(--($B$3:$B$32=$B3)*($A$3:$A$32=$A3)*$D$3:$D$32))