Microsoft Excel Worksheet Functions

P
How can I add the values based the color of font and the date
  • Peter Gonzalez
Replies
1
Views
354K
Bernard Liengme
B
L
Identify the windows just below the menu
  • Luismo
Replies
2
Views
97K
Dave Peterson
D
R
concatenate
  • rpmani
Replies
2
Views
215K
Dave Peterson
D
T
Finding the lowest cost for a product from a list
  • tt
Replies
2
Views
217K
Squeaky
S
B
Using text and formatting sum function in formula
  • Billy B
Replies
2
Views
421K
Squeaky
S
S
Can you sum the amount of type a word appears?
  • Scott_goddard
Replies
2
Views
51K
getting old
G
J
Formula
  • josvill2010
Replies
1
Views
45K
getting old
G
G
Finding NEXT to last, non zero numeric value in a row
  • gergster
Replies
3
Views
322K
Steve Dunn
S
W
Interval between now and next birthday
  • WilDeliver
Replies
3
Views
152K
Chip Pearson
C
E
comparing data in excel
  • Eightball
Replies
3
Views
186K
Steve Dunn
S
P
Sumproduct with a twist
  • Pam
Replies
4
Views
320K
Steve Dunn
S
V
search a row for a word and if found
  • Vibeke
Replies
2
Views
149K
Jarek Kujawa
J
P
Concentration Analysis
  • Phillip Olan'g
Replies
3
Views
79K
Jarek Kujawa
J
A
Logical function please
  • Amin
Replies
3
Views
118K
Amin
A
B
Pulling a cell reference--clickable cells?
  • Bermie
Replies
1
Views
286K
Steve Dunn
S
U
creating a report from a table, pivot table not suitable
  • UKMAN
Replies
1
Views
308K
Steve Dunn
S
K
Function similar to "LEFT"
  • Karen D
Replies
3
Views
237K
Jacob Skaria
J
J
copy formula
  • Jafferi
Replies
3
Views
271K
Jacob Skaria
J
B
Conditional Formatting Date Range
  • BWR_Rick
Replies
2
Views
262K
Lee Li Fong
L
T
CONCATENATE
  • Tservo
Replies
3
Views
82K
Ashish Mathur
A
T
SUM
  • Talladega
Replies
2
Views
333K
Ashish Mathur
A
E
Pivot table show all days of a month even if no data
  • Elan lent
Replies
2
Views
136K
Herbert Seidenberg
H
J
VLOOKUP returning formula
  • Jan Ogg
Replies
3
Views
414K
T. Valko
T
S
VLOOKUP & IF
  • Sarah
Replies
10
Views
248K
T. Valko
T
B
spreadsheet
  • Ben Rivera
Replies
1
Views
45K
CLR
C
N
Need function to return numbers at beginning of text
  • Nadine
Replies
2
Views
323K
T. Valko
T
C
Can excel data be encrypted?
  • Confused
Replies
1
Views
78K
Joe User
J
P
Add values based on text color with the criteria of a date
  • Peter Gonzalez
Replies
7
Views
393K
Peter Gonzalez
P
B
Add no. of days to a workday to get new workday?
  • blswes
Replies
1
Views
196K
Duke Carey
D
M
Compare 1 cell to column of cells returning adjacent cells info?
  • Mr. Fine
Replies
1
Views
206K
Duke Carey
D
B
Sort
  • Brandon
Replies
2
Views
231K
Tom Hutchins
T
W
rounded # to correct #
  • Wagnerk
Replies
3
Views
97K
Bernard Liengme
B
C
#N/A help please
  • cadustin
Replies
2
Views
543K
Duke Carey
D
S
Help with If Sum statement - i think....
  • Scott_goddard
Replies
4
Views
472K
Duke Carey
D
S
Rounding Up question
  • spreadsheetlady
Replies
2
Views
279K
Mike H
M
P
pounds shillings pence format in excel
  • peter
Replies
2
Views
469K
Bernard Liengme
B
E
Ad-In Rowliner
  • Eurika Stemmet
Replies
4
Views
540K
Gord Dibben
G
M
Excel IF Formulas
  • mgreen-NJ
Replies
2
Views
277K
mgreen-NJ
M
J
Show time as a negative figure
  • JCR1987
Replies
3
Views
297K
Hans Terkelsen
H
L
Convert percentage into margin
  • Linda
Replies
2
Views
218K
Bernard Liengme
B
M
how do I import data in excel form SQL server?
  • Mitch
Replies
7
Views
638K
Duke Carey
D
E
Countif/SumProduct
  • excelllllllll
Replies
4
Views
160K
excelllllllll
E
D
Directing cell contents to one of two cells dependent on its value
  • Debi
Replies
1
Views
234K
Gary''s Student
G
M
multiple dependent drop down lists
  • Mikej
Replies
6
Views
577K
Mikej
M
A
Adding a value to a customer ID?
  • Anne
Replies
4
Views
368K
Bernard Liengme
B
M
Sumif with multiple sum ranges in a sheet
  • MA
Replies
4
Views
489K
Teethless mama
T
C
Can I combine a Vlookup with an IF formula?
  • Claire
Replies
2
Views
68K
Duke Carey
D
E
Filldown starting from F2 instead of F1
  • Ephraim
Replies
5
Views
553K
Ephraim
E
S
Setting up an electrical register in Excel with expiry dates
  • Scotty
Replies
1
Views
402K
Mike H
M
D
directing cell contents dependent on its value
  • Debi
Replies
2
Views
305K
Mike H
M
You must log in or register to post here.
Back
Top