Search results

It works based on what you told us and was created in 365. It's probably your data or you didn't follow the instructions properly - attach a file showing it not working, please, because I can't troubleshoot it otherwise. This is the LAMBDA that is in Name Manager under the name DateFormat...

Attached is a workbook with a sample LAMBDA function called DateFormat. The LAMBDA is set up in Name Manager (on the Formulas Ribbon). Details about creating LAMBDAs in this way are here: https://www.ablebits.com/office-addins-blog/excel-lambda-function-write-calculate-use/ From that page:

Wht not just copy and paste it? Which version of Excel do you have? If you have 365, you might be able to create a LAMBDA function and store it with a suitable function name.

Maybe this rule? =AND(A1<>"",COUNTIF(A$1:A1,A1)=COUNTIF($A$1:$A$12,A1))

What do you mean? What's wrong with the function you are using? Attach a workbook with examples.

It’s modern foreign languages.

There's a comprehensive introduction here: https://corporatefinanceinstitute.com/resources/excel/index-match-formula-excel/

A bit shorter: =LET(t,TEXTSPLIT(A1,,"|"),IFERROR(--t,t)) where A1 contains the string.

Yes - too vague, but ... Let's assume that A1 contains 1 and I want B1 to add A1 to 10 but if A1 contains 2 I want B1 to multiply A1 by 10. Formulae for B1: =A1+10 =A1*10 Combined: =IF(A1=1,A1+10,IF(A1=2,A1*10,"N/A"))

Why? Just copy and paste it into E2. Don't be so lazy!!!

In E2: =IF(AND([Life Type]="Consumption Per Tundish",[UOM]="NOS"),[@[Act Cons]]/[@[No of Tun]], IF(AND([Life Type]="Cons Per Tundish",[UOM]="KGS"),[@[Act Cons]]/[@[No of Tun]], [@[Act Cons]]*[@[No of Tun]]))

Try this: =MIN(--CG27:CG32)

My experience is the opposite - most people do fill it in. And it saves time in most cases. It's a simple thing to implement: why rail so hard against something that might not be of any use to you, but would to everyone else in this thread? Seems you're just interested in being contradictory here.

Marc - you can continue to do what you like. Whether or not it's a major concern is completely irrelevant. All those asking for it want to know is if the owner is happy to implement it or not (and it is demonstrably easy to do so). All the owner needs to do is say 'yes' or 'no' rather than just...

Did you look at the solution I offered you at all? Your subsequent posts suggest not.

CF rule for I2: =AND($I2<>"",MONTH(I2)=MONTH($I2),YEAR(I2)=YEAR($I2)) Applies to: =$I$2:$I$2000,$Q$2:$U$2000

Which version of Excel are you using?

I'm sure it's not dead: somebody is paying to maintain the platform and keep it ad-free. It does seem, though, that whoever that is does not have any interest in facilitating this improvement, for watever reason. It would be courteous of that person to at least let the membership know one way or...

If the table names in the individual files contain the owner's name, then you will get that in a column on the right when you append the tables. Provide a sample file.

With date issues, it's the first thing I look for: 90% of date issues are related to this issue.

A2 is a date, B2 is text that looks like a date. Set the cells' formatting to GENERAL and you'll see the difference. You can use: =DATEVALUE(B2) so this formula: =A2=DATEVALUE(B2) will return TRUE.

:DD:DD:DD

It's AliGW, not AliG, as I have told you at least three times before. Please get my name rigt if you are going to use it.

That's TWO vowel changes.

I imagine there's a switch that needs flicking somewhere so that it appears like this (screenshot from MrE):