[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]

Excel thread i guess?

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: 14
Thread images: 1

File: 400404.png (48KB, 906x478px) Image search: [Google]
400404.png
48KB, 906x478px
Anyone has any idea on how to solve pic related using functions only?
>>
>>59981053
Use if, min, max, average
>>
>>59981144
Im gonna need instructions with more details.

I uploaded document here uploadfiles(dot)io(slash)s9353
>>
>>59981248
I've googled it for you faggot, check this for the instructions: https://exceljet.net/formula/max-if-criteria-match
>>
=sudo apt get gentoo
>>
This isn't a homework board. Do your own research first before posting here
>>
Check the database commands. They could easily do this.
>>
>>59981291
Doesn't work with multiple criteria.
>>
Utkan-senpai notice me ~
>>
>>59981053
Use the SUMIFS function and do your homework>>59981053
>>
>>59981496
There is no use for sumifs here. Only averageif, maxif and sumif. The later 2 are not available on excel 07
>>
>>59981053
If you were not a faggot and used SQL instead of excel

select [age group], min(age), max(age), avg(age)
from table
group by [age group]
>>
>>59981053
>>>http://www.4chan.org/rules#global2
>>
>>59981053
It's either =vlookup or =index
cant remember which one's which
or you could just use the cheat way and have excel sort it by "age group" than individually call =min, =max, =average
Or do what our friend: >>59981144 said if you prefer
Thread posts: 14
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.