I have text cells in a column that comes from a checkbox in a survey. the checkbox has an option list that people can select as many of the options as they want
Example of option list of checkbox
Business community - Small and Medium-sized
Hey Dear community,
I have problem with following formula
This is working formula
But this one is not working...
i wanna know how can i ask excel to sum if list1 is not on list2
Sheets("DATA").Cells(5, "V") = [sum(if((isnumber(match(list1,list3,0)))*(sifaris>0)*(list1<>list2)*,printed))]
Can anybody help me please?
On November 21, 1998 I posted the first answer at MrExcel.com. A simple little formula of =A2-DAY(A2)+1 got this whole thing started.
It is amazing that the community here has posted over 1 million threads in twenty years. We have a great knowledge base about Excel here and I love that I've had...
Youth Service - NEET / Youth Payment, Support and Training for Service Providers - Education, Programmes for Young People, Elder abuse,Local Community, Elder abuse
Intellectual Disabilities, Finding work, Community Courses, Work
I need to concatenate some cells, but this is tricky and I'm not sure how to do it. Example of data below:
Account: ABC Company
Sales Director 1
Account: XYZ Company
If I have a Large range and I want to create an array from it but with conditions, I am trying to find the fast way to do this, possibly Advanced filter? (I have tried but no luck)
there are probably many ways but the fastest? or pretty darn fast at least
My ranges are dynamic but...
This May and June, the ModelOff Team is traveling around APAC to hold local networking events - and you are invited to join the celebrations!
Six FREE drinks networking events will be held in Melbourne (May 26), Sydney (May 27), Singapore (June 9), Bangalore (June 10), Hong Kong (June 11) and...
On 22nd Nov 2014 we are hosting a SQL Saturday in London. It is being done under the umbrella of the PASS organisation, SQL Saturday is their free community events, but this is a very different SQL Saturday. We are aiming it Excel Pros who munge/crunch/manage data. There will be the usual nods...
I was checking out some statistics provided by Google Analytics. The graph at this page shows the top 20 countries for the first six months of the year.
Do you have any subjective comments about if this data feels...