Search results for query: *

Hi everyone In cell A2 I will key each time a different number representing the row with the data I would like to check. In my sheet, from row 5 to 1000 I have data already entered (each row contains data from column B to column CZ). I would like to have in cell A3 the formula...

I was just wondering if there is a way in the IF function to return a value if logic is true and not to change that value any longer. Thus, I receive online in Cell A1, 20 different prices everyday and I would like to have all them recorded starting from cell B1 to B20. When I write in every one...

I was just wondering if there is a way in the IF function to return a value if logic is true and not to change that value any longer. Thus, I receive online in cell A1, 20 different prices every day and I would like to have all them recorded starting from cell B1 to B20. When a write in every...

Hi everyone, I have no knowledge of VBA and I will need great help to solve this problem. Everyday, as they occur, every single price of a contract traded on the Sydney Futures Exchange is downloaded to my Excel 2007, starting from row 2 up to row 10,000 (+/-). I would like to filter all these...

Hi everyone. Happy New Year!!! I need to do some tests on a series of prices. Prices are entered manually (+/- 100 prices per day) in a single Excel row. For every new price I need to check whether it is at least 10 points above o below the latest price entered. If it is, I have to check the...

Hi guys. I would like to enter data in my desktop and it be be automatically entered in my laptop as well (say to have my Excel table in the desktop and the corresponding excel chart showing in my laptop). How do I do it? How do I connect both computers to work with the same Excel application...

Hi everyone. I have a chart which plots the daily movement of prices of a commodity. I would like to be able to write the correspondent price on top of each important point on the chart. How can I do that? I know I can write any title, any label, but I cannot write on the points connecting the...

Hi everyone. I have Sheet1 containing a Chart linked to another sheet (Sheet 2). Each cell in Sheet2 has a formula linked to another sheet (DailyData) and as the day progresses, new data is entered in DailyData. The formulas in Sheet2 then returns a value for the corresponding cell. But, my...

Hi everyone! B C 3 4 41 4 3 21 5 7 11 6 5 9 7 4 34 8 14 37 I need to build a summary table and in B20 I need to show the number of times that B3:B8<=5 AND C3:C8<=5; in B21 I need to show the number of times that B3:B8<=5 AND C3:C8 is...

This is a simple one. In Excel, when I press "Enter", it records the information and then the cursor moves one cell down. Is there a way to change this? Say, not to move one cell down unless I press the "down arrow key"? Thanks guys. Mark

Hi everyone. I can't get this right. I want a single formula to determine the highest value in a Range which fullfils two separate conditions. B C D E F G H 32 25 17 10 33 36 42 {=MAX(IF(AND(B3:F3>=G3-5,B3:F3>=H3-10),B3:F3,0))} It should return 33 but it...

Hello. We have 3 Workbooks ("Data", "Calc", "Rev"). "Data" contains 5 sheets (Sheet1,Sheet2,...). "Calc" contains 7 sheets (Sheet1, Sheet2,...) and "Calc" also contains 7 sheets. In "Data" we enter the daily information collected from our branches. "Calc" and "Rev" contain complexes formulas...

Hi guys. My workbook has 2 sheets: "Prices" and "Move". In the sheet "Prices", I determined the maximum price of a range (say B3:K3). Using an array, I determined its column number (say 7). Using VLOOKUP and CELL functions, I determined the column letter (say G) and recorded it in cell T3 and...

I need help as I can't get this right. I want to count how many prices in a large range (C17:C3215) are higher than the average price of the range and I also want to calculate the average price of those prices above the average price of the range. I thought I knew!! My formula...

I am designing a excel spreadsheet to generate daily signals related to the prices of wheat. Rows represent the days and columns represent the commodity price recorded every 10 minutes. For a Range D10:W10, for a particular day, I need to have 2 formulas written in AA10 and AB10 which would...