Recent content by dolphintabby

I am so sorry it seems the problem was that there were no blank rows in the table so I filtered out only N/A & that worked. Thank you all for all your help! & patience. It is greatly appreciated!!!

Yes I want to filter out N/A 's & blank rows. Only want rows over that have a date value in it. Chat AI suggested =FILTER(MainTable,ISNUMBER(DateValue(MainTable[D/O]))) But that gives me a #Calc! Error. So there must be something in the table messing it up.

No there is no space it is blank. I want to bring over only those cells that contain a date in them.

Oh yea sorry I forgot to put the 1st maintable on here but it is in my formula but I tried the >" " that part works but it is still bringing over the "N/A" 's not sure why.

The columns does gave blanks.

Why would this formula not work: =FILTER(MainTable[D/O]<>"N/A")+(MainTable[D/O]<>" ")) Table is named MainTable Column header is D/O It returns the whole table with all the typed in N/A's not the error N/A just a typed value N/A? Regards, Dorothy A

I have a large table of data and I want conditional formatting to highlight an item if it contains a specific part of a text. For example part number is Z10105 but there are 1,000 of parts that begin with that series Z10105MJB, Z10105QZR,...etc, etc and I want a flag of highlighting it if it...

Thank you. You were right. :)

I got this formula somewhere and it works fine on 1 file. I just tried to add it to another file and it returns #NAME? error. Now I can't find anything on this formula. Regards, ~Dee

I am trying to write an If statement that looks at a cell that has a calculated formula in it but if the answer is 0 for it to return a blank but if it is not 0 I want it to compare the results with the calculation in another cell on another worksheet (Cell=calculated average cycle time) and...

I tried to figure out how you added month and year to the pivot fields but I haven't been able to figure it out. How did you separate them out?

Wow you are awesome! Thank you :)

That is awesome but I also needed it divided across the top where it says FMQR by month I also need it by Type so horizontal access is by type and vertical like you have it by month. :)

See attached. :)

Okay it let me this time see attached