Microsoft Excel Worksheet Functions

Post thread
T
Getting the average from a column using date constrants
  • Trevor.
Replies
8
Views
509
Trevor.
T
R
Data validation dependant drop down on unsorted list
  • Reacher21
Replies
6
Views
1K
Roger D
R
M
Import underscore in coding every after 2 digits
  • Manos
Replies
4
Views
458
Dave Peterson
D
S
Sumproduct with 4 variables
  • Steve
Replies
2
Views
549
Steve
S
K
Lookup
  • Kaisa
Replies
3
Views
405
Jacob Skaria
J
B
concatif
  • Betty
Replies
5
Views
1K
antionu
A
M
how can i transfer data from one sheet to another without blank li
  • Manos
Replies
1
Views
421
Jacob Skaria
J
T
GETPIVOTDATA and (blank)
  • Tige Brown
Replies
0
Views
3K
Tige Brown
T
D
Keep lines when one column equals certain criteria
  • Donna
Replies
2
Views
516
Donna
D
E
IF and Right Functions
  • Elaine
Replies
10
Views
545
Elaine
E
R
Copying Cells with Fill Handle
  • RRG
Replies
3
Views
582
Gord Dibben
G
D
Categorizing Data Question
  • Demosthenes
Replies
4
Views
731
Pete_UK
P
C
background colour of sheet gone gray need to change to whit
  • Change Background colour of worksheet
Replies
1
Views
625
CLR
C
K
Conditional Formatting in Excel 2007
  • kvollmer
Replies
1
Views
410
Niek Otten
N
D
"#VALUE!" Cell Value
  • DisMusBeDaPlaz
Replies
1
Views
407
Niek Otten
N
W
How do I use sumifs -
  • wantfit
Replies
1
Views
509
Teethless mama
T
D
Counting by color
  • Danny Boy
Replies
3
Views
2K
Gord Dibben
G
W
Grouping on protected worksheets
  • wnwilkerson
Replies
4
Views
523
Gord Dibben
G
L
Excel - How to get tab to go to next unlocked cell across columns
  • Linda
Replies
3
Views
4K
Gord Dibben
G
A
why this strange result with vlookup
  • Amin
Replies
2
Views
540
Dave Peterson
D
B
xlbgnm in remote data
  • Bill Johnson
Replies
1
Views
3K
Aurelie Bonvillian
A
F
Conditional Formula Words
  • Fab
Replies
4
Views
343
JLatham
J
O
looking for a function that will populate opening a worksheet or t
  • Olivia
Replies
2
Views
444
Olivia
O
M
multiple IF calculations
  • mel
Replies
6
Views
382
mel
M
T
Default Cell value in changing environment
  • TheDrescher
Replies
3
Views
372
Luke M
L
A
Centreing Text In Excel Cells
  • Alan
Replies
1
Views
560
Duke Carey
D
T
copy paste value
  • Tomwireless
Replies
1
Views
451
Duke Carey
D
A
I want to compare two coloumn particular text, then count total
  • Ashraf C.H.
Replies
3
Views
400
Dave Peterson
D
J
How to get repeatable Excel RAND sequence?
  • Joe User
Replies
12
Views
2K
Hans Terkelsen
H
P
Columns labeled with numbers not letters
  • plumeria54
Replies
8
Views
647
John
J
J
Conditional more than one iif
  • JoeM
Replies
7
Views
470
JoeM
J
D
Formatting question with Round
  • DaveOfArkansas
Replies
3
Views
485
Duke Carey
D
M
More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..
  • M.Mahesh
Replies
2
Views
331
Pete_UK
P
J
combine multiple spreadsheets into one workbook
  • Jen
Replies
1
Views
571
Duke Carey
D
D
Logic Formula using colors in the formula?
  • Danny Boy
Replies
2
Views
582
Danny Boy
D
S
vlookup with two recors
  • siva_vlookup
Replies
1
Views
426
Mike H
M
P
Reference different lines in the same cell
  • Panos
Replies
1
Views
354
Stefi
S
G
How do I search for the second largest value in the array?
  • Golf
Replies
1
Views
425
Ms-Exl-Learner
M
C
Conditional format will not work without $ (removed to allow copyi
  • CW
Replies
2
Views
532
CW
C
A
How do I get the formula icon back on my toolbar?
  • Andrea confused
Replies
1
Views
429
FSt1
F
S
Excel 2003 make 1 date cell automatically change another date cell
  • Scotty
Replies
3
Views
1K
Scotty
S
Y
Pivot table to calculate variance showing budget and actual.
  • YY san.
Replies
2
Views
2K
Ashish Mathur
A
C
Counting values in an array where value in one column is not null
  • CW
Replies
5
Views
541
Ashish Mathur
A
M
logical (if a1=specific word, can c1 = value entered in a2?)
  • mel
Replies
2
Views
498
Fred Smith
F
N
Text to values
  • Nadine
Replies
4
Views
327
Nadine
N
M
how do i create a repeating student certificate using excel
  • maroo
Replies
2
Views
925
Billy Liddel
B
J
excel - horizont line above font X
  • jafre
Replies
3
Views
2K
T. Valko
T
S
Id'ing tabs that contain #REF!'s
  • Steve
Replies
16
Views
601
Steve
S
J
How do I update links from .xls sheets to .xlms sheets
  • June
Replies
2
Views
767
Duke Carey
D
J
Vlookup + sumif , but how????
  • Jessejames
Replies
4
Views
862
Roger Govier
R
Back
Top