Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't analyze web data
With help of a web query I update/refresh pricing data from the web, for some reason I cannot get results using sumproduct function. What is the problem with the data I got from the web, does anybody know? Just a simple lookup value seemed to work but I need tree values to lookup. In sheet 1 I partly coppied the old sheet and started experimenting with data, even if I fill out gaps with fake data, write the previously automaticaly substracted infor by hand, classs dismaer et. Still not working, anybody has an idea! For the sake of it I attached my file. Regerds, willem +-------------------------------------------------------------------+ |Filename: PIPE COST COMPARISON new.xls | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=165| +-------------------------------------------------------------------+ -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=106082 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I analyze data using time periods? | Excel Discussion (Misc queries) | |||
how to analyze data? | Excel Discussion (Misc queries) | |||
who to analyze data with more than 30,000 rows in excel | Excel Discussion (Misc queries) | |||
Analyze Data | Excel Worksheet Functions | |||
How do I analyze data from a survey in excel | Excel Worksheet Functions |