Hi, How can I concatenate these 2 cells: one is time and the other is text: 9:00 and AM and I want the result to be 9:00 AM =CONCATENATE(AD2, " ", AE2) I have...

Using Excel 2003... Trying to compare cells J4:Q4 to cell F4. F4 will be colored yellow if F4all cells in the range of J4:Q4 excluding blanks. If J4 is...

The Advanced Features Team is pleased to announce the release of the first version of their Add-In for MS Excel 2003. Part of this realease are the following...

I am trying to change the Columns titles. Example, Column A becomes Column Name, Column B becomes Column, Address. That way when I'm working on row 57 I can...

I have several Business Lines that submit General Ledger and/or DDA reconciliations monthly to me. Within each individual reconciliation (Excel Format),...

How do I create a formula to update weekly PTO time? I have to keep up with 300 employees PTO time on a weekly basis. Example: I accumlate 1.54 hours at the...

My original problem is listedbelow I am using Data Validation for selected vehicles on runs, but I need to stop people assigning a duplicate registration for...

I need to create a calculated field for Age from the birth date within a Pivot Table (Excel Office 2007). I can not create age in the data set because it is...

How can I use the Find function within an array formula to check a column to locate evey occurence of a string and subsequently sum the corresponding numbers...

Hi How do I get Excel to apply a certain formula (held in a central table) based on particular values in the same row? I don't want the actual result of...

Hello All I wanted to see the macros set in a workbook by pressing Alt+F11. However, when I double-click the option VBAProject (FileName.xls), I was prompt...

HI, I need a formula to create I need to count number of items in #SHEET1 $B:$B if VALUE in #Sheet1 $A:$A matches #SHEET2 $A3. Please Help Me.

Hi Could you please share with me how to create drop down list in Excel 2007? Thanks in advanced

I trying to use a formula to find Duplicates Entries in a Single Column. I tried some formulas I found it but they didn't work.

iam currently using the below formula, if there is no data for a month i am getting the #ref i have tried adding ifserror to input a 0 if necesary but...

I am looking at a Worksheet where it contains the folllowing formula:- =SUBTOTAL(109,) I can see and understand what the formula is doing and why it is doing...

As soon as I protect a worksheet the function button on the toolbar is greyed out. I can still type the formula into an unprotected cell manually, but can't...

What is the formula if i entered number (i.e, 5000/-) & it convert in word (i.e, Five Thousand Only)

Hi, I want to open a exsiting CSV file and set the Data Format of column A (Date and time) to Date (m/d/yyyy) and column width to certain number. I can open...

Hi. I have a large worksheet that contains records of avtivities from record 3 and onwards with logic link predecessors to other activities in columns E...