SUMIF(MID(A9:A500,5,1),Z,C9:C500) Whats wrong in my formula above? I am trying to add columns Data 1-4 separately if the mid letter is Z. The name has 4 numbers in the front and 2 at the end Total sumif sumif sumif sumif Name Data1 ...

I have a text box placed in a chart that links to another sheet/cell for its content. The value is a percentage. I can format the source text using conditional format, but the formatting doesn’t carry forward into the text ...

Spreadsheet contains macros. On startup of any spreadsheet the macros are disabled. To activate macros need to select option before proceeding. I thought to record macro to carry out this function. However the selecttion to OK a macro is disabled ...

I have that ~$ on a file but it & a file with the same name but with no signs in front are both empty ? Where is my data ?

Hi team, We got a big trouble while working on data in excel. We tried to copy a list of values that are straight not hide or unhide. And then paste to other sheet in same file in visible cells ...

Hy all! I am trying to highlight duplicate entries from different worksheets using conditional formating and is not woking. I’ve found this formula =NOT(ISERROR(VLOOKUP(A1;bannedworkers;1;0))) but it not works ; i’m using excell 2003. I have two worksheets;in the first sheet ...

have a computer with a preinstalled version of office 2013 and I want to reimage the computer. used to be that magical jelly bean would provide the key… not so with office 2013 where will I find the key on the computer?

A pdf document I open with Adobe Reader, says “Cannot find or create the font ‘ArialNarrow’. Some characters may not display or print correctly”. Will there be any missing text?

I have a list of test numbers and need one folder for each test number. Within the test number folder I need three subfolders with specific names. See below: Test Number Folder 12345 Subfolder 12345_Report Subfolder 12345_Photos Subfolder 12345_Videos

Hi, It’s been a while since my last post but now I again need help. (i’m a hopeless wretch) What I have is a data of 2 columns. Col A contains names and Col B contains numbers. There are no duplicate names. ...