3,966 reputation
323
bio website unknownoo8.deviantart.com
location Mauritius
age 22
visits member for 1 year, 2 months
seen Jul 8 at 5:01

...


Jul
8
revised Embedded IF(OR(IF) statement
Oops, horribly didn't type what I meant
Jul
7
comment Embedded IF(OR(IF) statement
@EoinOliver Ok, great! :)
Jul
5
comment Embedded IF(OR(IF) statement
Thank you, and no worries, it takes some time to get used to how the stackexchange sites work :)
Jul
5
answered Embedded IF(OR(IF) statement
Jul
5
comment Embedded IF(OR(IF) statement
Edit your question please.
Jul
5
comment Embedded IF(OR(IF) statement
I find it hard to understand what you are looking for. Your formula does not 'look for a string of text inside a cell', it only checks whether it's blank or not. Next, what if the three cells are not blank and contain different words? What word should be taken to the final column?
Jul
2
comment Finding Unique Values in 3 Columns
@user339937 SMALL will return the nth smallest value from a set of values. It is being applies on row number, not on the actual data. And for the other part, make sure that the ranges are correctly changed. E.g. $C$1:$C$6 might become $C$1:$C$500 and you will need to change this everywhere in the formula.
Jul
2
revised Finding Unique Values in 3 Columns
Edited in array usage
Jul
2
answered Finding Unique Values in 3 Columns
Jul
2
revised Finding Unique Values in 3 Columns
Formatting
Jul
1
comment How to calculate occurrences of some word in table
Use a pivot table.
Jun
30
comment How can I “turn on wireless capability” in Windows 7?
That's what was the problem on my laptop too. Didn't turn it off, but I guess it's another program that did.
Jun
30
comment Remove non number data from an excel array
The second formula actually works in the data there. You need to press and hold the buttons Ctrl and Shift then press Enter/Return. If you want all three values, select three horizontal cells, type in the formula in the first cell, then press and hold Ctrl+Shift, then press Enter.
Jun
27
comment Expanding a cell formula resolving all its references (precedents)
In any case, default formulae cannot look into the contents of another cell to see whether it is a formula or not, they only look at the result value.
Jun
27
comment Excel searching column and copying the cell next to it
@user339153 Awesome, thank you! :)
Jun
27
answered Excel searching column and copying the cell next to it
Jun
26
comment Merging End Columns in Multiple Worksheets in New Sheet
It will need VBA. Unless you have a list of all the worksheet names and the sheet names you extract the data from in the destination worksheet. You don't necessarily need VBA in such case.
Jun
26
answered count number of cells that meet certain criteria between two other cells with certain criteria
Jun
26
comment MS EXCEL 2010 formula
Your sample data doesn't match your format somehow... Also, any reason why you cannot get the length of each individual row and add them up?
Jun
26
answered How to match cell to column & return value based on that?