Consider using a pivot table and slicer. Slicer to select the categories (eg computer) and pivot table will display the items (speaker, mouse etc) ...
Try ="CEO minus " & COUNTA(A1:G1)
Please attach some examples. It will be easier for us to help you. Have you tried using FORMULATEXT() to display the formula instead of the value?
You can also try using a Pivot Table for all the results. I have attached a sample for your reference. Note that I have deleted some of your data a...
Hi abayomi In cell K4 enter =SUMIFS($F:$F,$A:$A,K1,$B:$B,TIME(23,55,0)) Drag across the required columns Hope this helps Sunny
Hi Erica See if this helps. Sunny
You need to refresh the Pivot Table to update any changes.
Apparently the cell A1 and A2 is formatted to 18 point and that is causing the issue. Hope this helps. Sunny
Just to join in the fun, a formula alternative =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"jpg","jpg::sku_abc_00X"),"X","1",1),"X",...
Hi Salim Just use =DAY(EOMONTH(G2,0))
Try wrapping the entire formula with another =IFERROR(<The entire formula>,"") The error is occurring because you are using a "" to subtract ...
Hi Doug If your data is in an Excel Table, then you can give this a try. In cell I2 enter : =IFERROR(IF(MID(I1,3,2)<>"99",LEFT(I1,2)&a...
Try =IFERROR(VLOOKUP("*"&C1&"*",$A$1:$B$5,2,FALSE),VLOOKUP(C1,$A$1:$B$5,2,FALSE))
Not very clear about your column G. You should show us what formulas you are using and what are your expected answers in case of #N/A. It is ver...
Try =WEEKNUM(VALUE(A2))