Microsoft Excel Worksheet Functions

P
Count subset-totals in column
  • Pluggie
Replies
4
Views
498K
Domenic
D
Z
Can i run 2 IF statements in one formula?
  • zak
Replies
3
Views
219K
David Biddulph
D
K
Worksheet Calculations not working
  • KPA
Replies
4
Views
448K
David Biddulph
D
F
VLOOKUP
  • Flipper
Replies
1
Views
185K
John Bundy
J
I
Absolute Reference not working
  • Iriemon
Replies
3
Views
311K
Iriemon
I
R
V Lookup & IF
  • Reenee
Replies
3
Views
320K
Gary''s Student
G
M
Query on Null (#n/a)
  • Mr. Platypus
Replies
1
Views
56K
John Bundy
J
B
formula to add year to date figures
  • Brian
Replies
3
Views
726K
Brian
B
T
Creating calendar that autopopulates dates based on event date ent
  • TxKarateMama
Replies
1
Views
50K
Pete_UK
P
O
Auto populate cell with info on other cell (Sheet)
  • Oscar
Replies
4
Views
381K
Oscar
O
C
SUMPRODUCT OR COUNTIF
  • chrisk
Replies
6
Views
553K
chrisk
C
B
Looking up a row of data
  • bfont
Replies
3
Views
486K
Dave Curtis
D
G
cumprinc, not sure how to use it, someone please show me steps ple
  • GACKT
Replies
1
Views
368K
Bernie Deitrick
B
J
Average
  • Jen_T
Replies
3
Views
313K
Glenn
G
J
Help converting text to date & time?
  • Jon M
Replies
2
Views
129K
Stefi
S
I
matching text to text in excel
  • Ikepri
Replies
3
Views
672K
Stefi
S
M
How can I show a validity by a prompted symbol in colour?
  • Maray
Replies
1
Views
145K
Pete_UK
P
E
Pulling out values
  • Emma Hope
Replies
2
Views
272K
Emma Hope
E
C
Changing the colour of a range of cells, some with formulas.
  • Champ
Replies
8
Views
350K
Pete_UK
P
D
Triggering a Flag after 10 days that excludes weekends and holiday
  • Danny Boy
Replies
3
Views
269K
Stefi
S
C
sumif and complex sum_range formulae
  • caro
Replies
2
Views
356K
caro
C
S
Duplicates and unique values
  • sragor
Replies
1
Views
309K
muddan madhu
M
M
Copying data to summary sheet
  • Max
Replies
2
Views
482K
Max
M
G
removing the "-" sign in a calucation
  • gma
Replies
7
Views
506K
Khoshravan
K
G
Reference to worksheets
  • Guest
Replies
4
Views
159K
Max
M
J
coditional Page Break
  • j4m3sc
Replies
3
Views
195K
Ashish Mathur
A
A
Calculate AVERAGe with #MISSING!
  • Arne Hegefors
Replies
2
Views
142K
Ashish Mathur
A
H
COUNT COMMON DATA
  • HARSHAWARDHAN. S .SHASTRI
Replies
3
Views
271K
Ashish Mathur
A
A
copy & paste
  • andrew
Replies
1
Views
134K
Max
M
A
how do you find many data?
  • andrew
Replies
3
Views
108K
Max
M
J
Subtotal
  • John
Replies
4
Views
541K
Ashish Mathur
A
V
Fill series of dates across worksheets in excel
  • Valhumf
Replies
1
Views
360K
Gord Dibben
G
T
How do you insert & delete rows in a protected worksheet?
  • Tiffany G.
Replies
1
Views
378K
Gord Dibben
G
J
How do I auto highlight a cell with the same data as another cell
  • john talbot
Replies
11
Views
952K
Pete_UK
P
I
Please explain this formula
  • Iriemon
Replies
2
Views
214K
Max
M
S
round up
  • Siteman
Replies
1
Views
232K
bapeltzer
B
V
IF Statments in Excel
  • Valerie
Replies
5
Views
624K
T. Valko
T
T
show all characters in a cell
  • tinks
Replies
1
Views
14K
Gord Dibben
G
D
how do I click on a drop down list and go to that data
  • Donna
Replies
1
Views
307K
Gord Dibben
G
N
WorkBook Update
  • NotGood@All
Replies
3
Views
336K
Gord Dibben
G
S
time calculation
  • Siteman
Replies
7
Views
487K
Siteman
S
S
convert text to hyperlink
  • se7098
Replies
2
Views
512K
se7098
S
I
PASTE SPECIAL
  • Indy-500
Replies
1
Views
231K
Khoshravan
K
N
How do I find dups across different columns
  • Nyrubi
Replies
1
Views
233K
Khoshravan
K
L
Different answers when using cell references as opposed to actual
  • leobensmom
Replies
3
Views
129K
Glenn
G
C
Help with creating a function
  • Craig
Replies
3
Views
101K
Craig
C
A
Not sure whether to use VLOOKUP or an IF statement
  • Allison1962
Replies
2
Views
433K
John
J
R
how can i use countif to count sundays in excel
  • Reverend Ken
Replies
1
Views
176K
Glenn
G
D
can I define validation range by function?
  • DPR
Replies
1
Views
199K
JE McGimpsey
J
M
Date Conversion
  • mecca
Replies
5
Views
116K
Rick Rothstein
R
You must log in or register to post here.
Back
Top