Microsoft Excel Worksheet Functions

Post thread
B
Hide #Value!
  • brainstewn
Replies
3
Views
434
Kassie
K
P
Percentile Logic
  • PAL
Replies
2
Views
571
Kassie
K
S
Conditional Formatting
  • Steve HKG
Replies
4
Views
487
Max
M
P
Percentile
  • PAL
Replies
1
Views
493
Mike H
M
A
Group rows (or hide rows) like in MS Project
  • Annie1904
Replies
2
Views
6K
Ashish Mathur
A
M
Pick the 5th number out of the following number 1002300.
  • Mojo
Replies
3
Views
453
T. Valko
T
C
Quadratic trend equation?
  • cptak
Replies
2
Views
2K
Mike Middleton
M
D
get that 0 outta there
  • dlotz
Replies
2
Views
406
Ron@Buy
R
M
Randomly add numbers in a group
  • Michelle
Replies
6
Views
653
Michelle
M
F
Table function
  • Fernando Lopes Jr
Replies
4
Views
299
John
J
M
IF statements
  • MED
Replies
1
Views
375
Gord Dibben
G
P
Pivot Tables
  • PAL
Replies
2
Views
373
Herbert Seidenberg
H
G
data validation list drop down text format too small
  • Guest
Replies
5
Views
10K
Gord Dibben
G
T
Can I set a cell value to a filter selection in Excel?
  • TC in CT
Replies
5
Views
577
Gord Dibben
G
L
Transposing data with Index function
  • Libby
Replies
3
Views
573
ryguy7272
R
D
Find product from date range
  • dlotz
Replies
5
Views
487
[email protected]
D
D
Min/Max multiple rows into another sheet
  • Dan
Replies
1
Views
310
Dan
D
M
Calculating Social Security
  • Mary Lou
Replies
3
Views
511
ryguy7272
R
K
Auto Populate a Cell
  • Ken
Replies
2
Views
1K
Jacob Skaria
J
P
Pivot Tables
  • PAL
Replies
1
Views
406
ryguy7272
R
J
Using XIRR in an array formula
  • James Buist
Replies
9
Views
5K
manuel f
M
J
use of wildcards in conditional formatting
  • JohnPM
Replies
4
Views
6K
T. Valko
T
M
Entereing an age and if statement in the same cell
  • Mithy1
Replies
1
Views
334
Pete_UK
P
R
Combining Functions (Sumproduct and Countif)
  • Richard Horn
Replies
5
Views
4K
Jacob Skaria
J
B
lookup if? sumproduct if? index/match?
  • Brad Autry
Replies
2
Views
648
Pete_UK
P
D
picking largest number
  • dnmusic
Replies
4
Views
444
JH
J
J
INT defect: Please try this on 2007 for me
  • JoeU2004
2
Replies
26
Views
1K
Charles Williams
C
A
Data Sorting
  • Anil Mishra
Replies
1
Views
402
Jacob Skaria
J
T
subtract a single cell from range of cells and then count
  • tworrall
Replies
8
Views
1K
tworrall
T
O
How to colour highlight empty cell
  • Owen P
Replies
2
Views
605
David Biddulph
D
K
If Function and Vlookups
  • Kita
Replies
2
Views
424
Atishoo
A
H
match value within any portion of lookup string in range
  • Hile
Replies
3
Views
802
Hile
H
B
Formula's
  • Bensum
Replies
1
Views
423
Mike H
M
A
set to display cursur on cell A1
  • Anoop
Replies
1
Views
404
Jacob Skaria
J
J
Change the colour
  • Jaf
Replies
1
Views
430
FSt1
F
D
Current region emulation
  • daverau
Replies
5
Views
589
daverau
D
D
how to search values ont several tabs
  • donarno
Replies
1
Views
356
Ashish Mathur
A
M
Connect different worksheets
  • Marten
Replies
2
Views
416
Ashish Mathur
A
Z
Sum Duplicates in Groups
  • Zesty
Replies
2
Views
456
Ashish Mathur
A
D
Where does Excel2007 save files -- not where I select?
  • Dick
Replies
1
Views
531
Barb Reinhardt
B
L
Determining Frequency of range
  • Leitodd
Replies
2
Views
417
T. Valko
T
D
Enter Data on one tab, then find matching data on another tab
  • Derek
Replies
2
Views
453
Jacob Skaria
J
L
Create a Condensed List from Imported Data
  • Lemmesee
Replies
3
Views
512
Jacob Skaria
J
T
Conditional Sum Based on Cell Background Color
  • Thomas M.
Replies
6
Views
1K
Thomas M.
T
J
How to 'split' data from 1 column into 2??
  • Jen
Replies
6
Views
805
Ron Rosenfeld
R
J
merging two worksheets
  • Jim B
Replies
3
Views
473
Pete_UK
P
J
use of define name functions
  • john folmar
Replies
3
Views
364
Ashish Mathur
A
V
Shared worksheet will not 'share'.
  • Vic1
Replies
1
Views
335
ryguy7272
R
B
LOOKUPS USING 2 SETS OF DATA
  • Bill
Replies
5
Views
468
Ashish Mathur
A
P
Shutting off all calculations
  • Peter
Replies
7
Views
436
ryguy7272
R
Back
Top