Microsoft Excel Worksheet Functions

Post thread
T
Getting the average from a column using date constrants
  • Trevor.
Replies
8
Views
579
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
481
Dave Peterson
D
S
Sumproduct with 4 variables
  • Steve
Replies
2
Views
570
Steve
S
K
Lookup
  • Kaisa
Replies
3
Views
425
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
430
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
546
Donna
D
E
IF and Right Functions
  • Elaine
Replies
10
Views
579
Elaine
E
R
Copying Cells with Fill Handle
  • RRG
Replies
3
Views
595
Gord Dibben
G
D
Categorizing Data Question
  • Demosthenes
Replies
4
Views
767
Pete_UK
P
C
background colour of sheet gone gray need to change to whit
  • Change Background colour of worksheet
Replies
1
Views
635
CLR
C
K
Conditional Formatting in Excel 2007
  • kvollmer
Replies
1
Views
415
Niek Otten
N
D
"#VALUE!" Cell Value
  • DisMusBeDaPlaz
Replies
1
Views
415
Niek Otten
N
W
How do I use sumifs -
  • wantfit
Replies
1
Views
519
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
548
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
563
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
363
JLatham
J
O
looking for a function that will populate opening a worksheet or t
  • Olivia
Replies
2
Views
455
Olivia
O
M
multiple IF calculations
  • mel
Replies
6
Views
419
mel
M
T
Default Cell value in changing environment
  • TheDrescher
Replies
3
Views
393
Luke M
L
A
Centreing Text In Excel Cells
  • Alan
Replies
1
Views
571
Duke Carey
D
T
copy paste value
  • Tomwireless
Replies
1
Views
475
Duke Carey
D
A
I want to compare two coloumn particular text, then count total
  • Ashraf C.H.
Replies
3
Views
421
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
677
John
J
J
Conditional more than one iif
  • JoeM
Replies
7
Views
500
JoeM
J
D
Formatting question with Round
  • DaveOfArkansas
Replies
3
Views
512
Duke Carey
D
M
More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..
  • M.Mahesh
Replies
2
Views
346
Pete_UK
P
J
combine multiple spreadsheets into one workbook
  • Jen
Replies
1
Views
583
Duke Carey
D
D
Logic Formula using colors in the formula?
  • Danny Boy
Replies
2
Views
613
Danny Boy
D
S
vlookup with two recors
  • siva_vlookup
Replies
1
Views
432
Mike H
M
P
Reference different lines in the same cell
  • Panos
Replies
1
Views
366
Stefi
S
G
How do I search for the second largest value in the array?
  • Golf
Replies
1
Views
437
Ms-Exl-Learner
M
C
Conditional format will not work without $ (removed to allow copyi
  • CW
Replies
2
Views
534
CW
C
A
How do I get the formula icon back on my toolbar?
  • Andrea confused
Replies
1
Views
435
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
559
Ashish Mathur
A
M
logical (if a1=specific word, can c1 = value entered in a2?)
  • mel
Replies
2
Views
510
Fred Smith
F
N
Text to values
  • Nadine
Replies
4
Views
348
Nadine
N
M
how do i create a repeating student certificate using excel
  • maroo
Replies
2
Views
926
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
683
Steve
S
J
How do I update links from .xls sheets to .xlms sheets
  • June
Replies
2
Views
784
Duke Carey
D
J
Vlookup + sumif , but how????
  • Jessejames
Replies
4
Views
891
Roger Govier
R
Back
Top