Search results for query: *

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...

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...

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...

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...

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...

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...

Hi guys, Im trying to return a text string from an array formula which is using an if statement to determine the required data. a simplified example of the formula is shown below: {=(IF(((F16:F19="m")*(E16:E19=132)),D16:D19))} i would be able to get this formulae to work if i was trying to...

Hi Guys, first off i'm new to VBA programming, and i am looking to increase my knowledge with it to help increase the efficeincy of certain manual process which i carry out in my job. Anyway i have had a quick search and cant seem to find the answer to my question in this forum. The problem...

Hi, I am looking to find the max or min value in a column for a gievn criteria. Lets say in column A I have a list of transformers, in column B i have the size of this transformer, then in column C i have the current in the transformer. So what im wanting to do is find the max & min value of...

Hi, As the title suggests im wanting to lookup up a table and select the maximum value for the given criteria. My table for example could look like this (see below) and i would be wanting to extract the maximum values for SB1B1A, SB1E3 etc. SB1B1A 30.662 SB1B1A 30.714 SB1B1A 30.6 SB1E3 11.839...

I generated the following formula hoping that it would automatically locate numbers on other spreadsheets. =VLOOKUP($A4,INDIRECT("'"&C$27&"\["&B$2&".xls]"&B$2&"'!$F:$H"),2,FALSE) Cell C27 contains file location (C:\data\harmonics\ etc.) cell B2 contains file name and tab name The formula...

I have the following code, which i use to change to size of screen dumps to 55% so i can get two objects per page. I was wondering how i change it so that it only chnages the object which I have selected? Sub ipsa55() Dim Inl As InlineShape For Each Inl In ActiveDocument.InlineShapes...

Hi Guys, Ive got the following code which takes the name of the worksheet modifies it slighty and displays it in a cell. e.g. worksheet name: 'TM L 1' Cell A1 will display: 'Transmission Line 1' =SUBSTITUTE(RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))),"TM...

I am trying to create a macro which will change the size of a selected object to 55%. Im wanting to do this so that i dont have to keep manually changing each object so that two can fit on a page. When i try to record a macro word wont allow me to select the object and in not familiar enough...

I was wondering if it is possible to get excel to show the worksheet name in a cell? i can get this to work the other way round e.g. i can select a certain worksheet based on a cell value using the INDIRECT function. Thanks

Hi there, im looking to setup a little macro that takes whats in the clipboard and does a paste special (picutre). Im using it to bring tables in from excel. Well i tried using the macro recorder, however it seems to think i am doing a normal paste operation: Selection.PasteAndFormat...

I have a text file which is imported into Excel using a macro which formats the column widths etc. At the moment the user manual types in the number of samples so that when plots are created from the table the macro knows how far down the table to take data from. e.g. if the user says there are...

I have used a macro that plot graphs from masses of data then formats the graphs for going straight into reports. When i recorded the macros i plotted the graphs in a particualr order, therefore if i run the macros in another order it doesnt work since the chart numbers are wrong. see code...

What I'm looking to do is have a main excel page with ten macro buttons each importing and plotting different graphs. For one of the options I would like the user to enter the a value (channel No.) into a cell for which they want a statistical plot. This statistical data will have already...

According to the help after have drawn my command button i should be able to right-click and on the shortcut menu it will offer the choice of assiging a macro to it... well this doesnt seem to happen on my version. Am i doing something wrong? I have already created a macro that brings in a...