Microsoft Excel Worksheet Functions

Post thread
B
Hide #Value!
  • brainstewn
Replies
3
Views
434
Kassie
K
P
Percentile Logic
  • PAL
Replies
2
Views
593
Kassie
K
S
Conditional Formatting
  • Steve HKG
Replies
4
Views
519
Max
M
P
Percentile
  • PAL
Replies
1
Views
522
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
455
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
418
Ron@Buy
R
M
Randomly add numbers in a group
  • Michelle
Replies
6
Views
668
Michelle
M
F
Table function
  • Fernando Lopes Jr
Replies
4
Views
329
John
J
M
IF statements
  • MED
Replies
1
Views
400
Gord Dibben
G
P
Pivot Tables
  • PAL
Replies
2
Views
400
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
597
Gord Dibben
G
L
Transposing data with Index function
  • Libby
Replies
3
Views
593
ryguy7272
R
D
Find product from date range
  • dlotz
Replies
5
Views
533
[email protected]
D
D
Min/Max multiple rows into another sheet
  • Dan
Replies
1
Views
320
Dan
D
M
Calculating Social Security
  • Mary Lou
Replies
3
Views
550
ryguy7272
R
K
Auto Populate a Cell
  • Ken
Replies
2
Views
1K
Jacob Skaria
J
P
Pivot Tables
  • PAL
Replies
1
Views
432
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
345
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
664
Pete_UK
P
D
picking largest number
  • dnmusic
Replies
4
Views
460
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
470
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
623
David Biddulph
D
K
If Function and Vlookups
  • Kita
Replies
2
Views
434
Atishoo
A
H
match value within any portion of lookup string in range
  • Hile
Replies
3
Views
834
Hile
H
B
Formula's
  • Bensum
Replies
1
Views
483
Mike H
M
A
set to display cursur on cell A1
  • Anoop
Replies
1
Views
406
Jacob Skaria
J
J
Change the colour
  • Jaf
Replies
1
Views
457
FSt1
F
D
Current region emulation
  • daverau
Replies
5
Views
590
daverau
D
D
how to search values ont several tabs
  • donarno
Replies
1
Views
378
Ashish Mathur
A
M
Connect different worksheets
  • Marten
Replies
2
Views
436
Ashish Mathur
A
Z
Sum Duplicates in Groups
  • Zesty
Replies
2
Views
458
Ashish Mathur
A
D
Where does Excel2007 save files -- not where I select?
  • Dick
Replies
1
Views
532
Barb Reinhardt
B
L
Determining Frequency of range
  • Leitodd
Replies
2
Views
418
T. Valko
T
D
Enter Data on one tab, then find matching data on another tab
  • Derek
Replies
2
Views
463
Jacob Skaria
J
L
Create a Condensed List from Imported Data
  • Lemmesee
Replies
3
Views
535
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
854
Ron Rosenfeld
R
J
merging two worksheets
  • Jim B
Replies
3
Views
519
Pete_UK
P
J
use of define name functions
  • john folmar
Replies
3
Views
374
Ashish Mathur
A
V
Shared worksheet will not 'share'.
  • Vic1
Replies
1
Views
342
ryguy7272
R
B
LOOKUPS USING 2 SETS OF DATA
  • Bill
Replies
5
Views
495
Ashish Mathur
A
P
Shutting off all calculations
  • Peter
Replies
7
Views
492
ryguy7272
R
Back
Top