Question about Computers & Internet

Ad

Assuming that all of your data is in a single row number 4 and between columns N and PF

Try:

{=OFFSET(N4,0,MATCH(TODAY(),N4:PF4,0)+1,1,1)}

The MATCH function looks up the value of today() in the range N4 to PF4 and returns the number of columns offset from the beginning of the range. (The 0 here does an exact match)

The OFFSET function returns a value from a cell a specified number of columns from a reference cell, in this case N4, which is the first column that contains the search data. We need to add on to this value to skip the Interest column.

Regards,

Daryl

Posted on Mar 19, 2009

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

This is a very handy process when you're totaling or subtotaling columns. On the cell that you want the 'total' in type '=sum(column letter row number),(column letter row number). The first 'column letter row number' is where you want the first cell to be started in the total factor and the second 'column letter row number) is the last cell you want added in the total factor. The help (?) section is good at explaining formulas. Hope this helps, keep this process handy if you use Excel much because it'll be helpfull each time you subtotal or total columns.

Bob

Bob

Sep 23, 2009 | Computers & Internet

Here's what you are looking for. Browse it and you can find it there all you want for shortcut keys. Follow this link below:

Microsoft Excel Shortcut keys

__Enter data by using shortcut keys____To____Press__

Complete a cell entryENTERCancel a cell entryESC**Repeat the last action****F4 or CTRL+Y****Start a new line in the same cell****ALT+ENTER**Delete the character to the left of the insertion point, or delete the selectionBACKSPACEDelete the character to the right of the insertion point, or delete the selectionDELETEDelete text to the end of the lineCTRL+DELETEMove one character up, down, left, or rightArrow keysMove to the beginning of the lineHOME**Edit a cell comment****SHIFT+F2****Create names from row and column labels****CTRL+SHIFT+F3****Fill down****CTRL+D****Fill to the right****CTRL+R****Fill the selected cell range with the current entry****CTRL+ENTER****Complete a cell entry and move down in the selection****ENTER****Complete a cell entry and move up in the selection****SHIFT+ENTER****Complete a cell entry and move to the right in the selection****TAB****Complete a cell entry and move to the left in the selection****SHIFT+TAB****Work in cells or the formula bar by using shortcut keys****To****Press****Start a formula****= (EQUAL SIGN)****Cancel an entry in the cell or formula bar****ESC****Edit the active cell****F2****Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents****BACKSPACE****Paste a name into a formula****F3****Define a name****CTRL+F3****Calculate all sheets in all open workbooks****F9 ****Calculate the active worksheet****SHIFT+F9****Insert the AutoSum formula****ALT+= (EQUAL SIGN)****Enter the date****CTRL+; (SEMICOLON)****Enter the time****CTRL+SHIFT+: (COLON)****Insert a hyperlink****CTRL+K****Complete a cell entry****ENTER****Copy the value from the cell above the active cell into the cell or the formula bar****CTRL+SHIFT+" (QUOTATION MARK)****Alternate between displaying cell values and displaying cell formulas****CTRL+` (SINGLE LEFT QUOTATION MARK)****Copy a formula from the cell above the active cell into the cell or the formula bar****CTRL+' (APOSTROPHE)****Enter a formula as an array formula****CTRL+SHIFT+ENTER****Display the Formula Palette after you type a valid function name in a formula****CTRL+A****Insert the argument names and parentheses for a function, after you type a valid function name in a formula****CTRL+SHIFT+A****Display the AutoComplete list****ALT+DOWN ARROW**

Microsoft Excel Shortcut keys

Complete a cell entryENTERCancel a cell entryESC

on Feb 11, 2011 | Computers & Internet

Try this formula=((A1)*(1+A2))-A3
Where:
A1 is the original Balance
A2 is the interest rate
A3 is the money paid for the preceding month

Apr 02, 2009 | Microsoft Excel for PC

The easiest way I could think to do this was using text formulae concatenate - The issue I thought you might have was the lack of spaces between each entry - hence the " "

=CONCATENATE(B2," ",B3," ",B4,B5,B6)

=CONCATENATE(B2," ",B3," ",B4,B5,B6)

Jan 25, 2009 | Microsoft Office Standard for PC

=10000*(1+0.96)^12

=10000*(1+0.10)^18

=10000*(1+0.10)^24

=10000*(1+0.10)^18

=10000*(1+0.10)^24

Dec 02, 2008 | Microsoft Office Professional 2007 Full...

insert a row above row 1 and use data>filter>autofilter

view your database however you like

view your database however you like

Nov 18, 2008 | Microsoft Excel for PC

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Computers & Internet

detail about growth formula in ms excel

Jan 23, 2008 | Computers & Internet

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Dec 19, 2007 | Computers & Internet

Dear Madiha35,

I would recommend the use of the Table Function in Excel.

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

Step 1: Enter your data into the worksheet.

Step 2: Create Table

Highlight the relevant data

On the insert tab, click on Table

Step 3: Verify Table range is correct, Click OK

Step 4: Select the cell you where you wish to Sum Data.

Click on Autosum.

Step 5: To Insert new data

Click on the sum row in the table, (Not the entire worksheet row)

Right click, Insert, Insert Table rows from above

Step 6: Enter new data in row

Step 7: Data is automatically calculated in formula.

Oct 22, 2007 | Computers & Internet

192 people viewed this question

Usually answered in minutes!

Can you send a sample set of data to my email id plz???

honey2509@yahoo.com

All the Best.

×