Microsoft Excel Misc

Post thread
D
how does this formula work: =LOOKUP(2,1/((COUNTIF(D6:D41,">"&D6:D41)=0)*(D6:D41<>"")),D6:D41)
  • Dave F
Replies
8
Views
22K
phyothetkhaing
P
H
Regression - scenario won't run - can't determine why
  • Harry
Replies
1
Views
6K
Madhumitha.N
M
G
auto move down after barcode data entery
  • Guest
Replies
2
Views
1K
Abdurahiman
A
A
Counting how many days since last accident occured on the job
  • aussiegirlone
Replies
11
Views
5K
IanB
I
E
how do decrement a value in excel
  • eXCEL QUESTION
Replies
3
Views
6K
John Travolta
J
J
Average by color VBA
  • jlclyde
Replies
6
Views
3K
JeriDawn
J
P
Remove check box that came with web page copy?
  • perstromgren
Replies
3
Views
9K
DPOLKADOT
D
G
Can excel count concurrent events given start and end times ?
  • Guest
Replies
4
Views
4K
jwinterton
J
G
Help with this macro
  • Guest
Replies
5
Views
540
saubhagyam
S
J
Cell reference in formula always returns a zero value
  • Jim Alderman
Replies
15
Views
38K
kcdillos
K
K
Using COUNTIF with MONTH in formula
  • Kevin
Replies
7
Views
14K
Grace Lee
G
L
excel displays "l" instead of "€" symbol for Euro values
  • lex63
Replies
3
Views
4K
HGP123
H
F
Remove Pattern Without Affecting Cell Color or Gridlines
  • Filibuster
Replies
8
Views
4K
Murray Snudge
M
B
Why can't I see my entire Worksheet on the Excel screen?
  • Brad
Replies
7
Views
55K
FrustratedwithExcel
F
G
File size limits in Excel-2003
  • Guest
Replies
3
Views
1K
ChrisGreaves
C
H
Display contents of a cell in a user form text box -- Excel 2003 VBA
  • hiskilini
Replies
7
Views
42K
faiz2011
F
X
How do I decrease the gap width of the Up/down bar?
  • Xcel08
Replies
4
Views
10K
bala6666
B
B
Rotating Text 180
  • Barb Reinhardt
Replies
6
Views
8K
Luddite1696
L
G
How do I turn text 180 degrees on Excel?
  • Guest
Replies
4
Views
3K
Luddite1696
L
G
Plotting diagonal axis in Excel or rotating charts
  • Guest
Replies
5
Views
2K
Parvenu
P
G
What does M.I. stand for in Job Applicant data and comparison tem.
  • Guest
Replies
4
Views
65K
Carmehlah
Carmehlah
M
Microsoft Query criteria syntax for date() or today()
  • Mark
Replies
4
Views
32K
Linsay
L
G
Remove Page Watermark [Page Break Preview]
  • Guest
Replies
11
Views
148K
mann
M
J
Problem with Amortization Table using beginning of period
  • jcooper
Replies
4
Views
6K
PRutherford
P
B
how can i make 0.6 = 1 in excel
  • Barfly
Replies
7
Views
6K
SureshJohn
S
G
filter: how to print filter list options in dropdown box
  • Guest
Replies
3
Views
6K
liamjos
L
P
How do i format a number into stones, pounds and ounces, please?
  • paula23234
Replies
5
Views
43K
Mike454
M
G
Hide rows with zero balances
  • Guest
Replies
11
Views
2K
Luciana
L
K
macro to hide columns with zero values?
  • K Dawson
Replies
2
Views
4K
Luciana
L
G
Get External Data grayed out
  • Guest
Replies
10
Views
15K
AJH
A
C
Hlookup-Drag to rows below
  • Carolina
Replies
5
Views
3K
Abdul Rahman
A
B
VBA equivalent to "echo off"
  • Brian
Replies
2
Views
23K
AmjiBhai
A
A
How to insert document property into excel field
  • aMc
Replies
4
Views
27K
AP12553
A
R
Why can't I access the footer?
  • Renee
Replies
10
Views
45K
Katie B
K
B
How do I get Random pairings in Excel?
  • bchappell
Replies
7
Views
44K
Barani Parthiban
B
P
How to format in stones & pounds and then present on chart
  • Pete Harris
Replies
2
Views
10K
Smezz
Smezz
K
How do I calculate standard error in excel?
  • Kyle
Replies
7
Views
231K
Laura_Joy
L
G
How do I auto transform sets of data? (change "female" to "f")
  • Guest
Replies
3
Views
14K
Doha
D
M
How do I display row numbers so I can click on a row?
  • Madison2007
Replies
3
Views
1K
MAX SCRUGGS
M
K
Missing row numbers
  • kingfisher
Replies
3
Views
1K
MAX SCRUGGS
M
H
Dependent Data Validation with Illegal Characters
  • hjneedshelp
Replies
8
Views
6K
UntilTomorrow
U
L
How to resize background
  • Luis Medina
Replies
5
Views
28K
OldWizard
O
M
Select drop down menu option using libre-calc macro
  • Muthulakshmi
Replies
0
Views
1K
Muthulakshmi
M
D
Averaging letter grades
  • Dr. Indera
Replies
6
Views
5K
Katie Mc
K
T
Cell won't highlight when selected
  • TJAC
Replies
1
Views
23K
DonL
D
J
Excel "file is already open"
  • John McFadden
Replies
6
Views
20K
dannyb242
D
P
Way to keep formulas unchanged when deleting rows?
  • PeteJ
Replies
9
Views
15K
Vaeryn
V
P
printing full bleed (ie. no print margins)
  • Pips
Replies
2
Views
5K
yogasadana
Y
G
Second most frequent number in a data set in Excel?
  • Guest
Replies
6
Views
11K
Josh Arcadia
J
A
add-in back to spreadsheet
  • Andrew McMichael
Replies
8
Views
3K
kthik24
K
Top