Microsoft Excel Worksheet Functions

R
Data validation dependant drop down on unsorted list
  • Reacher21
Replies
6
Views
477K
Roger D
R
M
Import underscore in coding every after 2 digits
  • Manos
Replies
4
Views
142K
Dave Peterson
D
S
Sumproduct with 4 variables
  • Steve
Replies
2
Views
321K
Steve
S
K
Lookup
  • Kaisa
Replies
3
Views
214K
Jacob Skaria
J
B
concatif
  • Betty
Replies
5
Views
92K
antionu
A
M
how can i transfer data from one sheet to another without blank li
  • Manos
Replies
1
Views
189K
Jacob Skaria
J
T
GETPIVOTDATA and (blank)
  • Tige Brown
Replies
0
Views
247K
Tige Brown
T
D
Keep lines when one column equals certain criteria
  • Donna
Replies
2
Views
256K
Donna
D
E
IF and Right Functions
  • Elaine
Replies
10
Views
223K
Elaine
E
R
Copying Cells with Fill Handle
  • RRG
Replies
3
Views
187K
Gord Dibben
G
D
Categorizing Data Question
  • Demosthenes
Replies
4
Views
277K
Pete_UK
P
C
background colour of sheet gone gray need to change to whit
  • Change Background colour of worksheet
Replies
1
Views
203K
CLR
C
K
Conditional Formatting in Excel 2007
  • kvollmer
Replies
1
Views
67K
Niek Otten
N
D
"#VALUE!" Cell Value
  • DisMusBeDaPlaz
Replies
1
Views
92K
Niek Otten
N
W
How do I use sumifs -
  • wantfit
Replies
1
Views
175K
Teethless mama
T
D
Counting by color
  • Danny Boy
Replies
3
Views
509K
Gord Dibben
G
W
Grouping on protected worksheets
  • wnwilkerson
Replies
4
Views
251K
Gord Dibben
G
L
Excel - How to get tab to go to next unlocked cell across columns
  • Linda
Replies
3
Views
450K
Gord Dibben
G
A
why this strange result with vlookup
  • Amin
Replies
2
Views
277K
Dave Peterson
D
B
xlbgnm in remote data
  • Bill Johnson
Replies
1
Views
175K
Aurelie Bonvillian
A
F
Conditional Formula Words
  • Fab
Replies
4
Views
142K
JLatham
J
O
looking for a function that will populate opening a worksheet or t
  • Olivia
Replies
2
Views
97K
Olivia
O
M
multiple IF calculations
  • mel
Replies
6
Views
166K
mel
M
T
Default Cell value in changing environment
  • TheDrescher
Replies
3
Views
238K
Luke M
L
A
Centreing Text In Excel Cells
  • Alan
Replies
1
Views
191K
Duke Carey
D
T
copy paste value
  • Tomwireless
Replies
1
Views
218K
Duke Carey
D
A
I want to compare two coloumn particular text, then count total
  • Ashraf C.H.
Replies
3
Views
214K
Dave Peterson
D
J
How to get repeatable Excel RAND sequence?
  • Joe User
Replies
12
Views
465K
Hans Terkelsen
H
P
Columns labeled with numbers not letters
  • plumeria54
Replies
8
Views
718K
John
J
J
Conditional more than one iif
  • JoeM
Replies
7
Views
389K
JoeM
J
D
Formatting question with Round
  • DaveOfArkansas
Replies
3
Views
304K
Duke Carey
D
M
More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..
  • M.Mahesh
Replies
2
Views
120K
Pete_UK
P
J
combine multiple spreadsheets into one workbook
  • Jen
Replies
1
Views
232K
Duke Carey
D
D
Logic Formula using colors in the formula?
  • Danny Boy
Replies
2
Views
291K
Danny Boy
D
S
vlookup with two recors
  • siva_vlookup
Replies
1
Views
45K
Mike H
M
P
Reference different lines in the same cell
  • Panos
Replies
1
Views
216K
Stefi
S
G
How do I search for the second largest value in the array?
  • Golf
Replies
1
Views
200K
Ms-Exl-Learner
M
C
Conditional format will not work without $ (removed to allow copyi
  • CW
Replies
2
Views
156K
CW
C
A
How do I get the formula icon back on my toolbar?
  • Andrea confused
Replies
1
Views
169K
FSt1
F
S
Excel 2003 make 1 date cell automatically change another date cell
  • Scotty
Replies
3
Views
387K
Scotty
S
Y
Pivot table to calculate variance showing budget and actual.
  • YY san.
Replies
2
Views
300K
Ashish Mathur
A
C
Counting values in an array where value in one column is not null
  • CW
Replies
5
Views
390K
Ashish Mathur
A
M
logical (if a1=specific word, can c1 = value entered in a2?)
  • mel
Replies
2
Views
104K
Fred Smith
F
N
Text to values
  • Nadine
Replies
4
Views
237K
Nadine
N
M
how do i create a repeating student certificate using excel
  • maroo
Replies
2
Views
229K
Billy Liddel
B
J
excel - horizont line above font X
  • jafre
Replies
3
Views
65K
T. Valko
T
S
Id'ing tabs that contain #REF!'s
  • Steve
Replies
16
Views
1M
Steve
S
J
How do I update links from .xls sheets to .xlms sheets
  • June
Replies
2
Views
104K
Duke Carey
D
J
Vlookup + sumif , but how????
  • Jessejames
Replies
4
Views
256K
Roger Govier
R
G
How to lookup multiple values and summing them up in one cell
  • Guest
Replies
10
Views
235K
Pete_UK
P
You must log in or register to post here.
Back
Top