Microsoft Excel Worksheet Functions

P
Percentile Logic
  • PAL
Replies
2
Views
357K
Kassie
K
S
Conditional Formatting
  • Steve HKG
Replies
4
Views
321K
Max
M
P
Percentile
  • PAL
Replies
1
Views
225K
Mike H
M
A
Group rows (or hide rows) like in MS Project
  • Annie1904
Replies
2
Views
220K
Ashish Mathur
A
M
Pick the 5th number out of the following number 1002300.
  • Mojo
Replies
3
Views
16K
T. Valko
T
C
Quadratic trend equation?
  • cptak
Replies
2
Views
361K
Mike Middleton
M
D
get that 0 outta there
  • dlotz
Replies
2
Views
174K
Ron@Buy
R
M
Randomly add numbers in a group
  • Michelle
Replies
6
Views
150K
Michelle
M
F
Table function
  • Fernando Lopes Jr
Replies
4
Views
156K
John
J
M
IF statements
  • MED
Replies
1
Views
167K
Gord Dibben
G
P
Pivot Tables
  • PAL
Replies
2
Views
234K
Herbert Seidenberg
H
G
data validation list drop down text format too small
  • Guest
Replies
5
Views
225K
Gord Dibben
G
T
Can I set a cell value to a filter selection in Excel?
  • TC in CT
Replies
5
Views
546K
Gord Dibben
G
L
Transposing data with Index function
  • Libby
Replies
3
Views
334K
ryguy7272
R
D
Find product from date range
  • dlotz
Replies
5
Views
335K
[email protected]
D
D
Min/Max multiple rows into another sheet
  • Dan
Replies
1
Views
79K
Dan
D
M
Calculating Social Security
  • Mary Lou
Replies
3
Views
419K
ryguy7272
R
K
Auto Populate a Cell
  • Ken
Replies
2
Views
194K
Jacob Skaria
J
P
Pivot Tables
  • PAL
Replies
1
Views
175K
ryguy7272
R
J
Using XIRR in an array formula
  • James Buist
Replies
9
Views
913K
manuel f
M
J
use of wildcards in conditional formatting
  • JohnPM
Replies
4
Views
227K
T. Valko
T
M
Entereing an age and if statement in the same cell
  • Mithy1
Replies
1
Views
138K
Pete_UK
P
R
Combining Functions (Sumproduct and Countif)
  • Richard Horn
Replies
5
Views
342K
Jacob Skaria
J
B
lookup if? sumproduct if? index/match?
  • Brad Autry
Replies
2
Views
116K
Pete_UK
P
D
picking largest number
  • dnmusic
Replies
4
Views
265K
JH
J
J
INT defect: Please try this on 2007 for me
  • JoeU2004
2
Replies
26
Views
809K
Charles Williams
C
A
Data Sorting
  • Anil Mishra
Replies
1
Views
243K
Jacob Skaria
J
T
subtract a single cell from range of cells and then count
  • tworrall
Replies
8
Views
811K
tworrall
T
O
How to colour highlight empty cell
  • Owen P
Replies
2
Views
188K
David Biddulph
D
K
If Function and Vlookups
  • Kita
Replies
2
Views
296K
Atishoo
A
H
match value within any portion of lookup string in range
  • Hile
Replies
3
Views
243K
Hile
H
B
Formula's
  • Bensum
Replies
1
Views
498K
Mike H
M
A
set to display cursur on cell A1
  • Anoop
Replies
1
Views
34K
Jacob Skaria
J
J
Change the colour
  • Jaf
Replies
1
Views
183K
FSt1
F
D
Current region emulation
  • daverau
Replies
5
Views
31K
daverau
D
D
how to search values ont several tabs
  • donarno
Replies
1
Views
211K
Ashish Mathur
A
M
Connect different worksheets
  • Marten
Replies
2
Views
198K
Ashish Mathur
A
Z
Sum Duplicates in Groups
  • Zesty
Replies
2
Views
44K
Ashish Mathur
A
D
Where does Excel2007 save files -- not where I select?
  • Dick
Replies
1
Views
32K
Barb Reinhardt
B
L
Determining Frequency of range
  • Leitodd
Replies
2
Views
53K
T. Valko
T
D
Enter Data on one tab, then find matching data on another tab
  • Derek
Replies
2
Views
155K
Jacob Skaria
J
L
Create a Condensed List from Imported Data
  • Lemmesee
Replies
3
Views
305K
Jacob Skaria
J
T
Conditional Sum Based on Cell Background Color
  • Thomas M.
Replies
6
Views
647K
Thomas M.
T
J
How to 'split' data from 1 column into 2??
  • Jen
Replies
6
Views
703K
Ron Rosenfeld
R
J
merging two worksheets
  • Jim B
Replies
3
Views
402K
Pete_UK
P
J
use of define name functions
  • john folmar
Replies
3
Views
217K
Ashish Mathur
A
V
Shared worksheet will not 'share'.
  • Vic1
Replies
1
Views
172K
ryguy7272
R
B
LOOKUPS USING 2 SETS OF DATA
  • Bill
Replies
5
Views
225K
Ashish Mathur
A
P
Shutting off all calculations
  • Peter
Replies
7
Views
511K
ryguy7272
R
Z
Sum Duplicates without Sorting
  • Zesty
Replies
3
Views
16K
Herbert Seidenberg
H
You must log in or register to post here.
Back
Top