Good afternoon, Is it unheard of to use a spreadsheet to, in a way, merge to an email. meaning, if I have a generic bodied letter, and a spreadsheet the...

Hi, I have a cell that I want to have a number and a letter in, ie 0.02 g. I need to be able to set this format based on another cells current formatting...

Hi, I have a macro tied to a button called UP Sub DPshiftup() ' ' DPshiftup Macro ActiveSheet.Unprotect With Range("Q16") If .NumberFormat =...

Hi, Im using ..NumberFormat & " \g" sucessfully, but I cant use .NumberFormat & " \kg" as excel says it cant set the number format. Why should it care...

I have this macro code: Range("u22:u26").NumberFormat = _ Range("ad22").NumberFormat '(number format in ad22 is "0.00") Dim KeyCell As Range, AnswerCell As...

Hi, I need some help... Here is my data: _____________________________________________ A B C D 1 ID Number ...

Hello I have a table that looks something like this: A B C D 1 0 0 0 1 2 0 0 0 0 3 0 1 0 0 4 0 1 1 0 5 0 0 0 0 6 1 0 0 0

Hello, I have some data that needs to be parsed...like this: Z:\02\ALPHA\0025.txt I'm trying to text to columns fixed width in order to get the 0025...

I have to check two columns to determine if I pull the sums from a third. So I need a sumif formula that accepts two criteria. For example: I need to get...

I am trying to look up a name and return a sum of all values in one column associated with that name. There are between one and five values for each name. I...

I have recently inherited a spreadsheet upon taking a new job, and one of the links in the sheet is broken. I do not need the link, and I have attempted to...

I am trying to determine the formula to count - only if the criteria in two (or more) cells is true. Example Data Set Service Equipment Data ...

I am trying to use the below formula in cell C7: =IF(P7=0,1,IF(P7=01,2,IF(P7=12,3,IF(P7=23,4,IF(P7=34,5,IF(P7=4,5,0)))))) The idea is that if P7 equals...

Hello, I am trying to perform a basic (!!) task which involves a table where the lowest figure requires to be highlighted. I used the formula in conditional...

I have a number of PCs which are running on XP office software. After using a machine running Office 2007, I was impressed with the find and select facility...

Good morning, Could someone please help with the below problem. I am new to this function in excel and after searching the community cannot find the answer...

Hello everyone, I am trying to get the following formula to work, without success. I would like C3 to have 3 possible outcomes, 1,2 or 3. This data will be...

Hello everyone, I am using the below formula to capture data from a table in my spreadsheet: =INDEX(F3:H22,MATCH(B9,E3:E22,0),MATCH(B3,F2:H2,0)) Within the...

Hello, I have a list of every postcode (column A) in the UK for work in excel 'sheet1'. Each postcode has a rating area A,B or C (column B). In the next...

I have an excel doc/table A3-M3 downwards. in N3 etc, I would like a button that, when pressed, will open a word.doc template and export data in A3 into a...