Search results for query: *

Thanks for your assistance - I'll give it a try and carry on :) All the best

Hi there, I need to build a file in VFP 7 that was running in Access 2000/2002. Is it possible to import it into VFP7 or should I just start all over? Otherwise, is it possible to create a runtime version in Access to demonstrate it with others? thanks

Sorry Man, I was not thinking - my values in cell F2 are compuyted and I forgot to round them to 2 decimals, thus the problem - thanks for all your help :) I can't believe I Was being so stupid! I should be able to do this in my sleep! thanks

I tried your last one and it's now giving me a result of $41.62, but I need to have either 41.90 (in this case) or 41.10 if the original cell value in f2 was 41.37 for example. thanks

thanks, but it's not working. For example, I have a value of $41.77 that I need to convert to $41.90 but it's giving me 17.67 as a result. I think there's something I'm missing. Here is what I converted it to on your suggestion...

Hi there, I have 2 scenarios that I want to cionvert my computed value to: if the value is greater than $xxx.50 then it should round to $xxx.90, if smaller than that, it needs to round down to $xxx.10 I've tried this: =IF(RIGHT(F2,3)>0.5,(LEFT(F2,2)+0.9),(LEFT(F2,2)+0.1)) but it is not...

OK - I am stupid :) I just realized that I should have used data validation and it's a solved problem now. Thanks

Hi, I have a combobox that allows me to choose a value from a defined list. I then want to reference the value in the box to calculate a number of lookup formulae. I can't seem to reference the value in the cell properly. I added the cell reference to the actual cell I have the combo box...

can it be done? I can't be entering 5000 result vectors every time the selection changes - is there a way to identify it using this sort of formula? MATCH('Retail routing'!D3,'LCR RATES'!(CONCATENATE("A",MATCH(A5,ratename)))):(CONCATENATE("u",MATCH(A5,ratename))))))))),0)-1...

I like the idea, but it's not the answer I need - I want to identify array a58 thruough u58 I'd like to use a match/concatenate function to identify them dynamically, but I can't seem to get it right - I have to look at a cell in column 1 and see which row it is in on sheet 2 then look for a...

Here's what I want to do: lookup array = a58:u58 can I somehow use a concatenate command or something to identify the row number? ie: =CONCATENATE("A",MATCH(A5,ratename)) (this gives me the desired text: a58) Is there some way of using this nested in a formula to identify an...

Thanks Datadan, Here's my problem - I have a large list (1036 rows) with some duplication of data (many instances of the same vendor name, however only one instance per row) and I need to find the row that corresponds to the destination, but I want to search for that row dynamically ( I can...

here's my problem: =INDEX(vendorrates,MATCH(A5,ratename),MATCH('Retail routing'!D3,'LCR RATES'!D58:U58,0)-1) How can I look up the row and find the value if I don't specify which row to look for the value in (the red part) This returns the right info, but it's not dynamic enough - I can't...

Hi, I have a excel question: I have a column of names, and I can use a match (=MATCH(A5,ratename))(= row 58) to find the row number, but I need to find a value in that row and then return the value to the left of it - I can find the column number if I specify the row array (=MATCH('Retail...

I have 2 tables - both share Ratename and Key_c; I would like to use a combo box to search a list of ratenames and then automatically list the data from the second table that needs to be amended or changed - I can't seem to find the right data/suggestions in any info I have - please help :)

Thank you - that helps a lot. But I still get the error in a few other formula calculations, such as: =SMALL(C14:AC14,4) =INDIRECT(ADDRESS(3,MATCH(SMALL(C14:AC14,4),C14:AC14,0)+2)) =((H4*V4)+(J4*W4)+(L4*X4)) =F4+(F4*T4)+S4 I don't know how to fix these - I must be missing something very...

I have a massive spreadsheet where in many cases the formula gives a #NUM! result if there is not a value in each of the referenced fields corresponding to the formula. I don't know how to eliminate them. Please help |-0

Dale - I'm sending you a small sample - I didn't make the post very clear - sorry. Thanks for your help. ;) Ashok

I have an excel spreadhseet with a row of 5 that i need to check against. They show: 5, 4, 3, 2, 1, or , , 3, 2, 1, or , , , , 1,. I need to fill a box with the first of the values that is not blank - I have over 700 rows to fill, thus a formula would simplify it. Thank you :)

It WORKED! Thanks for your help - it works like a charm and gets me out of hours of programming - you guys saved my life! Have a great weekend! S-)