Related tags:
resolved + (179)
spreadsheet + (82)
microsoft + (64)
office + (44)
formula + (42)
word + (42)
data + (40)
access + (29)
macro + (29)
database + (28)
spreadsheets + (23)
vba + (23)
software + (21)
chart + (20)
csv + (19)
mac + (19)
statistics + (18)
Merge + (16)
formulas + (15)
formatting + (15)
computer + (14)
charts + (14)
table + (14)
graph + (13)
computers + (13)
Outlook + (13)
PDF + (13)
windows + (13)
Excel2007 + (12)
msoffice + (12)
pivottable + (12)
Function + (11)
macros + (11)
MSExcel + (11)
pivot + (11)
programming + (11)
Math + (10)
html + (10)
format + (10)
columns + (10)
powerpoint + (10)
text + (10)
business + (9)
import + (8)
automation + (8)
microsoftoffice + (8)
osx + (8)
sort + (8)
Time + (8)
visualbasic + (8)
column + (7)
conditionalformatting + (7)
dates + (7)
date + (7)
email + (7)
graphs + (7)
numbers + (7)
scripting + (7)
sorting + (7)
google + (6)


Users that often use this tag:
TheBones (6)
malcommc (5)
zardoz (4)
willnot (4)
Anonymous (4)
anastasiav (3)
goethean (3)
mwhybark (3)
Mr. Justice (3)
keep it tight (3)
apark (3)
GilloD (3)
foxinthesnow (3)
SirStan (3)
jefficator (3)
corpse (3)
desjardins (3)
FireStyle (3)
jujube (3)
ttyn (3)
bluejayway (3)
Conrad Cornelius o... (3)
digiFramph (2)
Lentrohamsanin (2)
thankyoumuchly (2)
Flunkie (2)
freddymetz (2)
ewiar (2)
bleucube (2)
jestonb (2)
underwater (2)
slavlin (2)
johnstein (2)
beammeup4 (2)
pdb (2)
pantufla (2)
nevercalm (2)
rossination (2)
bigmusic (2)
elgilito (2)
wtfwjd? (2)
Bugbread (2)
digitalprimate (2)
Classic Diner (2)
bibbit (2)
SheIsMighty (2)
Rock Steady (2)
WCityMike (2)
nickerbocker (2)
panoptican (2)
nooneyouknow (2)
furtive (2)
ObscureReferenceMan (2)
pwb503 (2)
Jimbob (2)
jessamyn (2)
dmd (2)
synecdoche (2)
skryche (2)
stupidsexyFlanders (2)

In Excel I have 2 columns with dates in them. D1:D20 Start Date G1:G20 End Date. I want to highlight the cell in the range G1:G20 if the date is more than 14 days form the date in D1:D20. Obvious answer is conditional formatting, but I can't seem to create a formula with relative cell references. [more inside]
posted by willnot on Jan 30, 2012 - 6 answers

Can you help me construct a slightly complex Pivot Table in Excel? [more inside]
posted by willnot on May 14, 2009 - 6 answers

I have an Excel pivot table for sales performance data. I want to break that down for regional managers so that they only have access to their own offices' data while preserving the nice formatting that the pivot table provides. Is there an easy way to do that? [more inside]
posted by willnot on Aug 20, 2008 - 3 answers

Excel Question - Is there a way in Excel to evaluate whether a cell contains text that is in all caps as opposed to proper (first letter) caps. I know I can force cells into Upper or Proper, but I don't want to do that, i just want to flag and sort them.
posted by willnot on Sep 23, 2004 - 2 answers