I'm new to Office 2007, so am a little vaig on what to do. I'm trying to automate a Recod of Events (Times/ Distances) in Ecxell but can not get it to do...

my mind is totally not working right now. i want to create a popup message when someone clicks on a particular cell. i know this can be done with data,...

I want to input a value in one cell and get the info from another cell in another worksheet, eg I put 1234 it will give a name associate with that number

http://warnet.ws/img2/183/dom/4.jpg http://warnet.ws/img2/183/dom/1.jpg http://warnet.ws/img2/183/dom/3.jpg http://warnet.ws/img2/183/dom/5.jpg http://warnet.ws...

I have two spreadsheets that I need to merge and am using a VLOOKUP formula. Sheet 1 has ID numbers in column A; Sheet 2 has ID numbers in column A, last...

http://warnet.ws/img2/183/dom/4.jpg http://warnet.ws/img2/183/dom/1.jpg http://warnet.ws/img2/183/dom/3.jpg http://warnet.ws/img2/183/dom/5.jpg http://warnet.ws...

This formula was working and it no longer works: =IF(D163="Yes","",IF(VLOOKUP(C163,NIRAV,2)="","Not Scheduled",VLOOKUP(C163,NIRAV,2))) I believe it's an...

How can I get a cell in sheet1 to display the active cell address in sheet1 at all times without having to recalc when the active cell is changed? And if...

I need to count how many times certain phrases come up from multiple worksheets. Let me explain the problem more in detail. I have a worksheet for every day...

Hello dears I having datas as follows(Example) Sheet-1 Sheet-2 Col-A col-A Col-B AA-01 ...

Workbook to report all OT (overtime) performed during FY08 within a range of date for comparison to current FY usage. Two worksheets, 'Report' and 'FY08'. ...

I have a sorted column of account numbers that I want to count. I don't want to count more than one occurence of an account number if it has the same work...

Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column...

I need to be able to count an item if a key word is in a different columns. ex: Count the cells that contain "F17000" (Columns B & C) only if it is "Out of...

I would like to apply conditional formatting if a cell contains a formula as opposed to an entered number. I would think that is doable somehow using a...

I found this formula somewhere else on these boards ... The VALUE of the last NON-BLANK cell in a COLUMN range =LOOKUP(2,1/(A1:A100""),A1:A100) .......

I hope that this is the correct list for questions on MS Query, and Query Wizard in particular. From Excel Import External Data and connecting successfully...

Hi everybody i'm trying that Solver finds the best way to schedule several machines I have a table with 15 rows (4-18) the machines and 21 columns for the 7...

I don't know if this is possible or not: I import data from a manufacturing process. Column A - Date Column B - Product Name I want to have a table that...

Hi - I can't seem to figure this out, I bet it is pretty easy. Can anyone assist? The text is in A1. Thanks, Mike