|
|
fill a color to a row by
mns
Hi,
I want to check a column (lets say H) if there is a 1 value i want excel to
color the row.
lets say there is a 1 on H6, I want to fill a color to row 6....
( 1 2)
|
|
14 |
9,874 |
|
|
Vlookup & If by
Jac
Hi, I have a workbook, Master sheet containing this info :cell A4 contractor
name, B4 site location, c4 job cost etc to G4. There are several contractors...
( 1 2)
|
February 7th, 2010 09:21 PM
by John
|
14 |
302 |
|
|
Formula question?? by
Brad Grow
I need to know if there is a way to create a formula that will allow me to
enter multiple values in a cell at different times and this formula will sum
there...
( 1 2)
|
|
14 |
262 |
|
|
where is the Analysis Group in Excel? by
JeffM
I downloaded a Statistical Add-on for Excel. According to the help entry, I
am to look for the Analysis Group under the Data Tab and then click on Data
to...
( 1 2)
|
December 28th, 2009 06:00 AM
by Byron
|
14 |
462 |
|
|
Find missing sequential numbers by
DTTODGG
Hello, I'm looking for a way to quickly find what numbers are missing in
column B. I can sort them ascending, but how do I find if there are...
( 1 2)
|
March 10th, 2006 12:56 AM
by Biff
|
13 |
490 |
|
|
Work out overtime hours for individuals by
Fudge
Hi All
I have a question which i am hoping someone will eb able to help me
with, i have a spreadsheet which contains infromation for part time
hours worked...
( 1 2)
|
April 10th, 2006 04:10 PM
by Fudge
|
13 |
214 |
|
|
|
|
13 |
222 |
|
|
IF & Vlookup by
Sat3902
Afternoon,
I know some one out there might be able to assist me with my dilemna.
In Sheet1 I have a list of 8 digts id numbers in column A and in sheet2
is...
( 1 2)
|
August 11th, 2006 05:54 PM
by CLR
|
13 |
267 |
|
|
|
|
13 |
124 |
|
|
distinct values in column by
parthaemail
I like to format a column such that it allows only distinct values. for
eg in the column A i have 10 numbers 1to 10 (A1 to A10) . if i enter
any value between...
( 1 2)
|
|
13 |
423 |
|
|
|
January 17th, 2006 01:24 PM
by bzm
|
13 |
320 |
|
|
conditional formatting help please by
*k*
greetings......i have a row in which if say a4 contains the word help,
then all that row is in red text, othewise it is in black text
a1 a2 ...
( 1 2)
|
|
13 |
765 |
|
|
monthly Charges by
dk
how can we input a monthly charge every 21 st of the month the amount $25
shall automaticaly be entered on the same sheet
( 1 2)
|
September 19th, 2004 10:34 AM
by Max
|
13 |
394 |
|
|
due dates by
canman
I'm a Newbie that's been missiled into a job that requires many
spreadsheets to track recertification dates. The sheets are no problem
but I'd like to be able...
( 1 2)
|
January 10th, 2005 04:11 PM
by ewize1
|
13 |
322 |
|
|
average function in Excel 2002 by
Sherry
Hello all!
I wish to obtain the average of a number of numeric cells but wish this
average to be ongoing rather than restricted to a range of cells.
For...
( 1 2)
|
|
13 |
482 |
|
|
|
June 30th, 2005 03:21 PM
by Max
|
13 |
696 |
|
|
|
July 6th, 2005 01:27 PM
by olasa
|
13 |
339 |
|
|
Excel to replace words ? by
Andy100
How do i get excel to replace words from data imported from the net.
Here is the problem. I am using excel to fetch data from a flight timetable,
however,...
( 1 2)
|
August 28th, 2005 05:17 PM
by Andy100
|
13 |
186 |
|
|
|
|
13 |
422 |
|
|
VBA in Excel by
yaya1899
Halo, im a newbie 2 both VBA and Excel, I was assigned to design a VBA
script which can post query and retrieve data from an excel sheet, is
it possible to do...
( 1 2)
|
June 3rd, 2004 11:36 AM
by CLR
|
13 |
523 |