Microsoft Excel Worksheet Functions

Post thread
E
Count with 1 variable & 1 constant criteria formula
  • Excel-User-RR
Replies
3
Views
665
Excel-User-RR
E
P
Count subset-totals in column
  • Pluggie
Replies
4
Views
526
Domenic
D
Z
Can i run 2 IF statements in one formula?
  • zak
Replies
3
Views
485
David Biddulph
D
K
Worksheet Calculations not working
  • KPA
Replies
4
Views
382
David Biddulph
D
F
VLOOKUP
  • Flipper
Replies
1
Views
381
John Bundy
J
I
Absolute Reference not working
  • Iriemon
Replies
3
Views
447
Iriemon
I
R
V Lookup & IF
  • Reenee
Replies
3
Views
447
Gary''s Student
G
M
Query on Null (#n/a)
  • Mr. Platypus
Replies
1
Views
231
John Bundy
J
B
formula to add year to date figures
  • Brian
Replies
3
Views
1K
Brian
B
T
Creating calendar that autopopulates dates based on event date ent
  • TxKarateMama
Replies
1
Views
449
Pete_UK
P
O
Auto populate cell with info on other cell (Sheet)
  • Oscar
Replies
4
Views
499
Oscar
O
C
SUMPRODUCT OR COUNTIF
  • chrisk
Replies
6
Views
505
chrisk
C
B
Looking up a row of data
  • bfont
Replies
3
Views
368
Dave Curtis
D
G
cumprinc, not sure how to use it, someone please show me steps ple
  • GACKT
Replies
1
Views
706
Bernie Deitrick
B
J
Average
  • Jen_T
Replies
3
Views
363
Glenn
G
J
Help converting text to date & time?
  • Jon M
Replies
2
Views
380
Stefi
S
I
matching text to text in excel
  • Ikepri
Replies
3
Views
354
Stefi
S
M
How can I show a validity by a prompted symbol in colour?
  • Maray
Replies
1
Views
366
Pete_UK
P
E
Pulling out values
  • Emma Hope
Replies
2
Views
402
Emma Hope
E
C
Changing the colour of a range of cells, some with formulas.
  • Champ
Replies
8
Views
563
Pete_UK
P
D
Triggering a Flag after 10 days that excludes weekends and holiday
  • Danny Boy
Replies
3
Views
537
Stefi
S
C
sumif and complex sum_range formulae
  • caro
Replies
2
Views
640
caro
C
S
Duplicates and unique values
  • sragor
Replies
1
Views
537
muddan madhu
M
M
Copying data to summary sheet
  • Max
Replies
2
Views
480
Max
M
G
removing the "-" sign in a calucation
  • gma
Replies
7
Views
397
Khoshravan
K
G
Reference to worksheets
  • Guest
Replies
4
Views
324
Max
M
J
coditional Page Break
  • j4m3sc
Replies
3
Views
503
Ashish Mathur
A
A
Calculate AVERAGe with #MISSING!
  • Arne Hegefors
Replies
2
Views
522
Ashish Mathur
A
H
COUNT COMMON DATA
  • HARSHAWARDHAN. S .SHASTRI
Replies
3
Views
364
Ashish Mathur
A
A
copy & paste
  • andrew
Replies
1
Views
296
Max
M
A
how do you find many data?
  • andrew
Replies
3
Views
315
Max
M
J
Subtotal
  • John
Replies
4
Views
497
Ashish Mathur
A
V
Fill series of dates across worksheets in excel
  • Valhumf
Replies
1
Views
2K
Gord Dibben
G
T
How do you insert & delete rows in a protected worksheet?
  • Tiffany G.
Replies
1
Views
1K
Gord Dibben
G
J
How do I auto highlight a cell with the same data as another cell
  • john talbot
Replies
11
Views
796
Pete_UK
P
I
Please explain this formula
  • Iriemon
Replies
2
Views
757
Max
M
S
round up
  • Siteman
Replies
1
Views
433
bapeltzer
B
V
IF Statments in Excel
  • Valerie
Replies
5
Views
457
T. Valko
T
T
show all characters in a cell
  • tinks
Replies
1
Views
340
Gord Dibben
G
D
how do I click on a drop down list and go to that data
  • Donna
Replies
1
Views
275
Gord Dibben
G
N
WorkBook Update
  • NotGood@All
Replies
3
Views
357
Gord Dibben
G
S
time calculation
  • Siteman
Replies
7
Views
494
Siteman
S
S
convert text to hyperlink
  • se7098
Replies
2
Views
468
se7098
S
I
PASTE SPECIAL
  • Indy-500
Replies
1
Views
393
Khoshravan
K
N
How do I find dups across different columns
  • Nyrubi
Replies
1
Views
394
Khoshravan
K
L
Different answers when using cell references as opposed to actual
  • leobensmom
Replies
3
Views
562
Glenn
G
C
Help with creating a function
  • Craig
Replies
3
Views
385
Craig
C
A
Not sure whether to use VLOOKUP or an IF statement
  • Allison1962
Replies
2
Views
456
John
J
R
how can i use countif to count sundays in excel
  • Reverend Ken
Replies
1
Views
5K
Glenn
G
D
can I define validation range by function?
  • DPR
Replies
1
Views
404
JE McGimpsey
J
Back
Top