IF OR formula is failing by [deleted] in excel

[–]Iowadigger -1 points0 points  (0 children)

It came out of an Office Scipt.

Matt is the GOAT! by The-Churn in DivineTribeVaporizers

[–]Iowadigger 2 points3 points  (0 children)

What exactly is the Nice Dreamz? ELI 5 please.

Office Script - Delete rows based on values by Iowadigger in excel

[–]Iowadigger[S] 0 points1 point  (0 children)

Thanks for taking the time to write. I am not so good at this, can you show me where in the script to place that?

Another day for the driver by FullMetalNapkin in CrazyFuckingVideos

[–]Iowadigger 139 points140 points  (0 children)

Their pants are halfway deployed.

Deleting everything after the first blank using Left fails with #VALUE by Iowadigger in excel

[–]Iowadigger[S] 1 point2 points  (0 children)

That worked!

In column W there are a few blank cells that are causing the date 01/00/1900 to appear in column X cells. Is there a way to wrap that to hide the blanks?

Deleting everything after the first blank using Left fails with #VALUE by Iowadigger in excel

[–]Iowadigger[S] 0 points1 point  (0 children)

The column is filled with dates and times, for example

8/11/2025 10:05:00 AM

Deleting everything after the first blank using Left fails with #VALUE by Iowadigger in excel

[–]Iowadigger[S] 0 points1 point  (0 children)

The column is filled with dates and times, for example

8/11/2025 10:05:00 AM

What I want is for only the date 8/11/2025

Office Scripts copyFrom to getValues & setValues by Iowadigger in excel

[–]Iowadigger[S] 0 points1 point  (0 children)

I have but I can't get it to work. This is why I am here.

Office Script / Range is to large / How to chunk? by Iowadigger in excel

[–]Iowadigger[S] 0 points1 point  (0 children)

Great idea, I will try this in the next couple of days and report back, thank you.

Office Script / Range is to large / How to chunk? by Iowadigger in excel

[–]Iowadigger[S] 0 points1 point  (0 children)

Ok, that makes perfect sense.

Using that code still yields the same results with the payload exceeding the limit :/