Finding largest 2 values in a range using excel formula -

-

i have data below

classifiaction              hours home                157.40 home                157.39 mens apparel        157.39 mens apparel        157.39 sunglasses          157.39 sports              157.33 biss                157.33 mens apparel ia     157.32 mens apparel ia     157.32 kitchen             157.32 beauty              157.32 home                157.32 home                157.31 mens apparel        157.31 mens apparel        157.31 sunglasses          157.31 sports              157.29 biss                157.29 mens apparel ia     57.29 mens apparel ia     157.29 kitchen             157.28 beauty              157.28

from looking solution find largest 2 hours under each category.

like below

beauty  157.32  '1st largest value in under beauty beauty  157.28  '2nd largest value in under beauty  mens apparel    157.39  '1st largest value in under mens apparel mens apparel    157.39  '2nd largest value in under mens apparel

using large function.i'm able find largest 2 hours in whole range not each category(classification).

this work if numbers non-negative:

=large(($a$2:$a$23="beauty")*$b$2:$b$23,1)

i'm assuming data starts in a1 , formula should entered array formula (press ctrl+shift+enter instead of enter , formula should appear in curly braces {=large...}.

what copy column somewhere, remove duplicates , put 1 in next column them, copy whole thing underneath , put 2 instead of 1 , sort if afterwards. way can build formulas based on table

beauty          1 beauty          2 biss            1 biss            2 home            1 home            2 kitchen         1 kitchen         2 mens apparel    1 mens apparel    2 mens apparel ia 1 mens apparel ia 2 sports          1 sports          2 sunglasses      1 sunglasses      2

Comments

Post a Comment

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

-
i plot number of emails in inbox on time using gmail api , i'm seeing lot of drop-outs, whatever reason i'm getting incomplete count of messages @ single time points. my plots here: https://plot.ly/~tdsmith/2 -- "drop-outs" i'm complaining trace shoots downwards , recovers previous level @ next timepoint. the code i'm using count emails here: https://github.com/tdsmith/gmail-plotly/blob/master/gmail-plotly.py#l47-l64 what can diagnose these faults?
Read more

Installing Android SQLite Asset Helper -

-
i need use ready made database. search solution on internet did not work until decided use mentioned library found here . however, found hard use library in installation procedures shallow beginners. i appreciate step step procedure on how use android studio. in struggle tried copying sources main/libs , adding line gradle did not work. use api 19 if helps. update here build.gradle // top-level build file can add configuration options common sub-projects/modules. buildscript { repositories { mavencentral() } dependencies { classpath 'com.android.tools.build:gradle:0.11.+' compile 'com.readystatesoftware.sqliteasset:sqliteassethelper:+' // note: not place application dependencies here; belong // in individual module build.gradle files } } allprojects { repositories { mavencentral() } } trying compile project error error:(9, 0) no signature of method: org.gradle.api.internal.artifacts
Read more

Qt Creator - Searching files with Locator including folder -

-
one quick question qtcreator : know possible use locator open files using "ctrl-k" shortcut. however, possible search files including locations? for example, let's want locate file named "main.cpp" in folder named "myfolder" , have lots of other main.cpp files. what should type locator in order open ? just type myfolder/main.cpp in locator
Read more