Search results

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):

I've added mine. I would have expected it to appear under my avatar in this thread, but it doesn't. Can't see anyone else's, either.

@Luke M Thanks for keeping on trying. :)

Keep us posted. :)

@Luke M Well, I've just glanced at the documentation attached to post #24 and it looks as if a custom text field under the avatar to collect whatever information you like is entirely possible. No need to move to other software! So - how about giving it a try?

Thanks for reopening this thread. It has had a huge benefit on ExcelForum. It means that we can easily target the version being used when offering solutions. There is such a vast difference nowadays between what functions are available, even between 2019, 2021 and 365, that having some idea of...

You are getting an error with this: =COUNTIF(INDEX(FILTER('Raw data'!$E$3:$P$72,'Raw data'!$B$3:$B$72="Inactive"),0,MATCH('Working sheet'!G4,'Raw data'!$E$2:$P$2,0)),">0") because the worksheets referenced in it aren't there. We can't help when there is crucial data missing from the sample...

Attach a workbook.

Which version of Excel are you using?

Yes, of course, and none of them has responded to your tagging them. So who else is there that we can approach? How else can we get a response from them? If it's not possible to do, then all that one of them has to do is say so here and in the earlier thread. Why their unwillingness to engage...