Search results for query: *

xlhelp.. this was my idea that i would have the main XY plot then a subset of corrds which i would then overlay to give the time at specitic points.. it's getting the label onto the x,y graph that im having the problem with.

Hi Im looking to plot an XY series which also has a corresponding time stamp e.g. time (s) X Y 1.0 5 6 1.1 6 9 2.5 8 1 .... it's easy enough to get the XY plot, however im having trouble trying to get the time stamp associated with the specific XY coordinates. The data...

at selected points on the curve i would be looking to have the time stamp shown otherwise it would be too cluttered. I've actually managed to do this in openoffice, however it our work computers don't have OO and I don't think our IT dept would allow me to install it on a company laptop.

Hi Im looking to plot an XY series which also has a corresponding time stamp e.g. time (s) X Y 1.0 5 6 1.1 6 9 2.5 8 1 .... it's easy enough to get the XY plot, however im having trouble trying to get the time stamp associated with the specific XY coordinates. The data...

Thanks Skip. Your code worked a treat!!

Ive attached the excel template with some entries. In column D i would be looking to determine the category from the corresponding description in column B. Hope this make more sense... Thanks again Chrishttp://www.box.net/shared/hqhccgzry1

that sounds to me like a DATA problem (YOUR problem) that no computer can fix"... there is no problem to fix. im just trying to find a certain string in entry description. Here is a simple example... 1. SHELL 01/12/08 #89183631 2. HEB #5630 87905 3. EXXON 11/11/09 Houston 4. 11/12 KROGER...

ultimately ill use a pivot table once i have the simplified groups, but because the descriptions can vary for the same type of entry, i.e. include time stamps, account numbers etc. it's not possible to use the pivot table yet.

Hi, Im trying to catagorise entities in a list into smaller predetermined groups, e.g. take a bank statement and you want to group all entries related to food shopping, drinking, car etc. etc. Col A Col B Col C [description] [value] [group] i was trying to use an...

Cheers! Works a dream. I also found another solution... use OpenOffice :)

Hi, im looking to add a lable to each point on a chart, however rather than gicing the x,y coords. id like to give it a name, e.g A, B...C is this possible... my spreadsheet is set up with col A containing the identifier, col B containing the X coord, and col C containing the Y coord. At...

Cheers guys!

70,000 yep... its a sparse matrix.. lots of zeros but all other values are unique

Hi im looking to find the cell ref of a particular number in an array, e.g. A B C -------- 1| x y b 2| l m j 3| h i e so in this simple example i might want ot know where "m" is located... B2 Im having trouble coming up with a formula to find this cell reference. Note that...

is there a computation advantage using sumproduct instead of an array forumla with sum and if statements, e.g. {=sum(if((A1:A10="motor")+(B1:b10="cont"),C1:C10))} i have massive spreadsheets which are colating data from many sources and some of them can take tens of seconds to calculate (using...

okay that would make sense, i thought there might have been a neater way to do it. Thanks all the same

Earlier on today some of you guys gave me some good tips on using SUMPRODUCT to perform criteria based array functions. previously i had used array formulas with SUM and IF statements, however these appear to be alot slow on the scales im using them for. My question relates to using the...

Okay having played about with it for a few minutes i see that it turns the criteria into true or false values (1 or 0) and returns the row number based on the criteria... i like it! thanks again

Cheers Glenn

Cheers Glenn, works like a dream! any chance of a breif explanation of how that little function works?