...on A5 on sheet2, enter a link ( the = ) and enter. copy this formula down. Do the same with Sheet3 linking to Sheet1. When you sort Sheet1, Sheet 2 and 3 will follow. Hope this helps. Regards ...
...copy the formula on sheet 4/A1 to the other cells: Select cells A1:A12 on sheet 4. (in other words, highlight all the cells that will become the top row of the table on sheet 4.) Now press Ctrl-R. ...
Question about Microsoft Computers & Internet
...formula could be structured: Sample Data (columnar arangement): A1: Part B1: Code C1: Price D1: Find Part E1: Find Code A2: x B2: 11 C2: 5.00 D2: y E2: 12 A3: x B3: 12 C3: 6.00 D3: y E3: 11 A4: y B4: ...
Question about Microsoft Office Computers & Internet
Copy data that contains formula and paste it to a new sheet minus the formula: is this possible? Sure is - depending on your version of Excel. 1) right click on the cell with the formula 2) go to ...
formula Sorry for messing around but I am new to all of this so I will start again: I have 2 worksheets named DCT INFO and DCT. In DCT INFO I have 2 columns - A has positions (some are missing so it's
...text when you put in the reference "J~" Be dure you are entering a formuila and not test that looks like a formula (to you) You should probably use COPY and then PASTE SPECIAL rather that regular ...
...x in the formula above with the number of the last row of data in your lookup table on Sheet2. You can copy and paste this formula down the column to calculate your other values. Hope that helps! ...
...each worksheet by students name. Data..Sort. 6. Copy the scores from one sheet to another. 7. You then you can manipulate the scores and compare anyway you like by using formulas in different
Question about The Computers & Internet
...the data by copy whole sheet (click on the square in top left hand and copy and then right click paste special on new worksheet - with values only rather than the original formulas from the ...
...formula =IF(ISBLANK(A3), 0, A3). This function tests if A3 is blank. If it is, it returns a 0. If it's not, you get A3 again. (But A3 has to really be blank -- spaces will count as non-blank.) Then, ...
944 questions posted
Usually answered in minutes!
7,277 Questions
239 Questions
265 Questions
207 Questions