Excel stuff

pspdfppdfxhd · February 05, 2024, 10:28:52 AM

I am filtering out each column for blanks and putting the +"" formula in the blanks. Seems ok so far.

Joe · February 05, 2024, 10:33:02 AM

Quote from: pspdfppdfxhd on February 05, 2024, 10:28:52 AMI am filtering out each column for blanks and putting the +"" formula in the blanks. Seems ok so far.

What formula is +"" .

Or do you mean ="" ?

pspdfppdfxhd · February 05, 2024, 10:47:35 AM

Looks like it's working. Thanks for all this help.

If it's not right they tell me and I will have to go to plan B. Get an expert to do it.

If I can't find an expert I will go to plan D. Retire. I would be pretty poor but it's a new challenge!

pspdfppdfxhd · February 05, 2024, 10:48:56 AM

Quote from: Joe on February 05, 2024, 10:33:02 AM
Quote from: pspdfppdfxhd on February 05, 2024, 10:28:52 AMI am filtering out each column for blanks and putting the +"" formula in the blanks. Seems ok so far.
What formula is +"" .

Or do you mean ="" ?

Yes, my bad. Typo, I meant ="". (hit the shift key by mistake).

pspdfppdfxhd · February 05, 2024, 11:13:54 AM

Where did you find out all this Joe, I thought you were a straight up prepresser.

I googled this thing to death and couldn't find an answer.

Joe · February 05, 2024, 11:27:58 AM

Just google searches and finally ran across the ="" formula. Didn't save the website and now can't find it again.

I did some VDP in my prepress life. Not a lot but some.

pspdfppdfxhd · February 05, 2024, 11:40:10 AM

Quote from: Joe on February 05, 2024, 11:27:58 AMJust google searches and finally ran across the ="" formula. Didn't save the website and now can't find it again.

I did some VDP in my prepress life. Not a lot but some.

Well you must be a better "googler" than I.

"I did some VDP in my prepress life. Not a lot but some." (some is enough).

Joe · February 05, 2024, 01:01:32 PM

Quote from: pspdfppdfxhd on February 05, 2024, 11:40:10 AM
Quote from: Joe on February 05, 2024, 11:27:58 AMJust google searches and finally ran across the ="" formula. Didn't save the website and now can't find it again.

I did some VDP in my prepress life. Not a lot but some.
Well you must be a better "googler" than I.

"I did some VDP in my prepress life. Not a lot but some." (some is enough).

Do you have Excel? I did find something that says Excel outputs blank cells as ,"", instead of the way LibreOffice does it as ,, with the double comma signifying an empty cell.

pspdfppdfxhd · February 05, 2024, 03:10:37 PM

Never had any luck getting excel to do these sorts of things. I think you might have to get into macros or scripting... way beyond my pay grade.

I was just wondering, for what purpose did libre put that strange little invisible formula in for =""?

For this specific purpose? It's strange, but from what i can see in the text file it worked. I sent it off for testing so i will know soon.

Ear · February 05, 2024, 04:12:10 PM

I hear that... I thought a Pivot Table was millennial speak for a Lazy Susan.

pspdfppdfxhd · February 05, 2024, 04:52:28 PM

Dunno, but i have just started getting pretty ok with the barre chords after one year. Pivot tables are even scarier. Hard to budge that wall of frustration.

Ear · February 05, 2024, 05:07:23 PM

I've seen the Excel groupies... not much incentive compared to the barre chords.

born2print · February 05, 2024, 05:12:14 PM

With practice, the pain of forming those shapes will ebb...
so don't fret! lol

pspdfppdfxhd · February 05, 2024, 06:23:33 PM

DigiCorn · February 05, 2024, 07:40:14 PM

Quote from: Ear on February 05, 2024, 04:12:10 PMI hear that... I thought a Pivot Table was millennial speak for a Lazy Susan.

Try going to google.com and type, "Ross Friends," in the search window. Then click on the couch icon. Make sure you have your speakers on.

News:

Excel stuff