[Boards: 3 / a / aco / adv / an / asp / b / bant / biz / c / can / cgl / ck / cm / co / cock / d / diy / e / fa / fap / fit / fitlit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mlpol / mo / mtv / mu / n / news / o / out / outsoc / p / po / pol / qa / qst / r / r9k / s / s4s / sci / soc / sp / spa / t / tg / toy / trash / trv / tv / u / v / vg / vint / vip / vp / vr / w / wg / wsg / wsr / x / y ] [Search | Free Show | Home]

Any Excel bros in /g/? I need to highlight (or get boolean value)

This is a blue board which means that it's for everybody (Safe For Work content only). If you see any adult content, please report it.

Thread replies: 6
Thread images: 1

File: Image_PictureOfData_713x389.png (132KB, 713x389px) Image search: [Google]
Image_PictureOfData_713x389.png
132KB, 713x389px
Any Excel bros in /g/?

I need to highlight (or get boolean value) for cells that have more than 4 # characters.

So far I haven't found any info on it.

Does /g/ know the formula?

Also, how many of you use excel or other office products for work?
>>
I'd use IF and LEN in custom conditional formatting.
>>
Use conditional formatting with the rule =LEN(J5)-LEN(SUBSTITUTE(J5,"#",""))>4

I mostly use Google Spreadsheets at work.
I only use Excel for Pivot tables and looking at csv's these days.
>>
>>56420508
Here's what I'm working with,

Every cell has something like this in it:

##Description##

And then the actual text description.

In this descriptions, some may have a # like #1 for instance.

I need to find every cell that has more #'s than just the ones in ##description##

That's why I don't think Len will work.
>>
>>56420543
I will try this and let you know.
>>
>>56420543
You're the man. It worked. Thanks.
Thread posts: 6
Thread images: 1


[Boards: 3 / a / aco / adv / an / asp / b / bant / biz / c / can / cgl / ck / cm / co / cock / d / diy / e / fa / fap / fit / fitlit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mlpol / mo / mtv / mu / n / news / o / out / outsoc / p / po / pol / qa / qst / r / r9k / s / s4s / sci / soc / sp / spa / t / tg / toy / trash / trv / tv / u / v / vg / vint / vip / vp / vr / w / wg / wsg / wsr / x / y] [Search | Top | Home]

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible.
Read more on this topic here - https://archived.moe/talk/thread/1694/


If you need a post removed click on it's [Report] button and follow the instruction.
DMCA Content Takedown via dmca.com
All images are hosted on imgur.com.
If you like this website please support us by donating with Bitcoins at 16mKtbZiwW52BLkibtCr8jUg2KVUMTxVQ5
All trademarks and copyrights on this page are owned by their respective parties.
Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.
This is a 4chan archive - all of the content originated from that site.
This means that RandomArchive shows their content, archived.
If you need information for a Poster - contact them.