5 posts tagged with excel by malcommc.

Displaying 1 through 5 of 5.

resolved + (192)

spreadsheet + (88)

microsoft + (68)

office + (51)

data + (47)

Formula + (45)

word + (45)

access + (35)

macro + (30)

database + (30)

spreadsheets + (25)

VBA + (24)

software + (22)

chart + (22)

Mac + (21)

csv + (20)

statistics + (20)

charts + (18)

merge + (17)

formatting + (16)

computer + (15)

formulas + (15)

msoffice + (15)

pdf + (14)

outlook + (14)

graph + (14)

table + (14)

computers + (14)

msexcel + (13)

excel2007 + (13)

windows + (13)

programming + (13)

macros + (13)

powerpoint + (12)

function + (12)

math + (12)

microsoftoffice + (12)

pivottable + (12)

pivot + (11)

columns + (10)

html + (10)

format + (10)

business + (10)

Text + (10)

graphs + (9)

Email + (9)

visualbasic + (9)

sort + (8)

microsoftexcel + (8)

sorting + (8)

dates + (8)

import + (8)

time + (8)

osX + (8)

automation + (8)

scripting + (7)

conditionalformatting + (7)

column + (7)

average + (7)

google + (7)

TheBones (6)

malcommc (5)

Anonymous (4)

willnot (4)

FireStyle (4)

desjardins (4)

zardoz (4)

SirStan (3)

Jackie_Treehorn (3)

jujube (3)

goethean (3)

skypieces (3)

jefficator (3)

bluejayway (3)

mwhybark (3)

anastasiav (3)

Conrad Cornelius o... (3)

undercoverhuwaaah (3)

stupidsexyFlanders (3)

sdis (3)

foxinthesnow (3)

Mr. Justice (3)

ttyn (3)

corpse (3)

GilloD (3)

keep it tight (3)

apark (3)

Carialle (2)

bluefly (2)

demagogue (2)

bibbit (2)

Irontom (2)

Seeba (2)

Rad_Boy (2)

skryche (2)

thankyoumuchly (2)

synecdoche (2)

Lentrohamsanin (2)

digiFramph (2)

Jimbob (2)

rippersid (2)

furtive (2)

monocultured (2)

jestonb (2)

lea724 (2)

beammeup4 (2)

xedrik (2)

sockpim (2)

pwb503 (2)

nickerbocker (2)

ObscureReferenceMan (2)

crapmatic (2)

pantufla (2)

rorycberger (2)

prunes (2)

ParisParamus (2)

WCityMike (2)

dmd (2)

ewiar (2)

squorch (2)

i need to gather data from paginated tables and return them as a feed or something that can be easily pulled as a query into excel. [more inside]

posted by malcommc on Oct 21, 2010 - 4 answers

posted by malcommc on Oct 21, 2010 - 4 answers

YTD total based on sum of last number in another row that has a value?
I need to sum up the values in one row based on the matching row below it. For example, if I have a target of $1000 a month, and I only have actual revenue numbers through June, I would like to calculate the year to date for the target from Jan to June. Once July numbers are put in, I'd want the YTD for the target to update to Jan to Jul.
I have tried a couple of variations on COUNT, INDEX and OFFSET.
Example is here: http://malcommc.com/ytd.xls
I am using Excel 2003

posted by malcommc on Jul 12, 2010 - 12 answers

posted by malcommc on Jul 12, 2010 - 12 answers

Need a formula to look for two values in another sheet, and return a third corresponding value. Example provided (google spreadsheet.) [more inside]

posted by malcommc on Dec 28, 2009 - 5 answers

posted by malcommc on Dec 28, 2009 - 5 answers

I am trying to pull values from one sheet into another master sheet for daily trending. The OFFSET function works for a single cell, but I can't figure out how to copy that formula to the rest of the column. [more inside]

posted by malcommc on Oct 26, 2009 - 13 answers

posted by malcommc on Oct 26, 2009 - 13 answers

I need a formula to help calculate the number of days as compared to a range.
Importing a CSV for a query to show bookings within the date range of 9/1 to 9/30. Some bookings are booked through the entire month and some are partial. I need to figure out the number of days or percentage for the bookings that don't run all the way through the query range. [more inside]

posted by malcommc on Oct 1, 2009 - 9 answers

posted by malcommc on Oct 1, 2009 - 9 answers

Page:
1