Microsoft Excel Worksheet Functions

Post thread
G
How to tell if cell contains a FORMULA or user-entered number?
  • Guest
Replies
11
Views
620
AnimalMagic
A
S
Vlookup functions which could not recognise similar alphanumerics
  • Shawn
Replies
2
Views
460
AnimalMagic
A
T
Make cell contents blank upon opening worksheet
  • Tacrier
Replies
1
Views
347
Max
M
G
Calculating the value of a cell from another cell
  • GPark1018
Replies
2
Views
408
Gord Dibben
G
G
help with pivot tables
  • Guest
Replies
3
Views
276
Infinitogool
I
S
Display row of the maximum in a list
  • Sungibungi
Replies
2
Views
388
T. Valko
T
H
average formula
  • hserphillips
Replies
2
Views
359
Harlan Grove
H
N
Filter by Date of Birth
  • Naomi
Replies
12
Views
1K
Naomi
N
L
How to Change Column Header from numbers back to letters
  • Luke
Replies
2
Views
600
FSt1
F
N
Condensing a list with duplicates to a list with non-duplicates
  • Nuclear
Replies
2
Views
843
M Kan
M
T
How can I filter just 2 columns (separated by another column)?
  • theglove33
Replies
2
Views
400
Gord Dibben
G
K
What would I set up this formula
  • Karen
Replies
4
Views
405
David Biddulph
D
S
#VALUE! error message in simple sum function
  • Sandog
Replies
4
Views
495
Sandog
S
L
Adding sums from different worksheets
  • laurabell
Replies
2
Views
392
Gord Dibben
G
X
Is it possible to filter using row height in Excel
  • xBRITO
Replies
2
Views
2K
Gord Dibben
G
V
Still need help with IF and Count Function
  • Vicki
Replies
11
Views
620
T. Valko
T
S
find the cells that represent a code in one cell
  • shane
Replies
1
Views
262
Gord Dibben
G
S
How do I use a variable as a reference to an array in INDEX
  • Steve Haack
Replies
6
Views
448
T. Valko
T
T
XL2002 - VLOOKUP with variable Sheet Name
  • Trevor Williams
Replies
3
Views
715
Pete_UK
P
S
Write a formula using two arrays, across two worksheets
  • Susan
Replies
11
Views
635
David Biddulph
D
R
IF function
  • Rebecca
Replies
4
Views
400
David Biddulph
D
J
Multiple If Statements in the same cell
  • JBarsema
Replies
2
Views
327
ryguy7272
R
L
Adding Rows
  • leimst
Replies
2
Views
362
ryguy7272
R
S
"IF" Condition
  • shafali
Replies
1
Views
335
PCLIVE
P
G
How can I calculate total spend on items that have different values
  • gorbash.uk
Replies
1
Views
532
John C
J
G
INDEX / MATCH with SUMIF/COUNTIF/SUMPRODUCT Statements?
  • Guest
Replies
10
Views
2K
Pinto G
P
S
Formula being replaced by =#N/A
  • Scopar
Replies
1
Views
606
VoxBox-Richard
V
D
Summing between two dates
  • Don
Replies
6
Views
394
Pete_UK
P
S
Counting Records Between Two Dates
  • Stevo
Replies
7
Views
492
Pete_UK
P
R
Exporting list from Excel to PP, I want a new slide for each cell
  • RecycleMicol
Replies
1
Views
265
Reitanos
R
T
If with multiple or
  • TFMR
Replies
5
Views
261
John C
J
T
Need to report a count that meets multiple criteria.
  • tkm
Replies
2
Views
541
Stephen Lloyd
S
D
Excel not correctly calculating formula
  • Darren Ingram
Replies
5
Views
1K
Pete_UK
P
A
how to make a cell mandatory in the excel sheet
  • Asif
Replies
2
Views
631
Gary Brown
G
V
Multiple Data Validation
  • VoxBox-Richard
Replies
3
Views
329
Bob Phillips
B
L
convert US dates to UK dates
  • Labuscs
Replies
2
Views
471
Dave Peterson
D
S
display unique data into third sheet
  • Sri
Replies
3
Views
414
MYNAMPATI
M
P
if val in col3 is one of 13 codes (list), apply factor to val in c
  • PBcorn
Replies
1
Views
487
Dave
D
F
Multiple Critiera Sum Array - One critiera to be between two numbers
  • Forgone
Replies
3
Views
340
Forgone
F
W
IF function? to turn around answers in questionaire
  • Windav
Replies
3
Views
392
Bob Phillips
B
A
sumproduct help.
  • angel
Replies
3
Views
413
Bob Phillips
B
S
Regarding Formula for Date and time
  • Samuel Jacob
Replies
1
Views
338
Bob Phillips
B
M
Lowest two values
  • Muz
Replies
4
Views
449
Bob Phillips
B
A
Copy & paste block of text number of times equal to value in cell
  • azoll
Replies
1
Views
566
ryguy7272
R
H
Help required
  • Hassan
Replies
2
Views
290
Hassan
H
S
MS Excel 2007
  • sherrysboyfriend
Replies
2
Views
188
RagDyer
R
J
Lookup Formula Question
  • JWNJ
Replies
1
Views
295
Max
M
A
Ignore blank cells when calculating date for If, Then function
  • AndreaS13
Replies
2
Views
815
AndreaS13
A
B
SUMIF
  • Brad Bross
Replies
5
Views
312
RagDyer
R
J
lookup or vlookup
  • jamalhakem
Replies
7
Views
479
Max
M
Back
Top