Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
fill formula
Name: mom Date: November 2, 2005 at 11:06:55 Pacific OS: xp CPU/Ram: 3.8
Comment:
i have a spreadsheet with a number in a1 the next number is in a15 and so on down the page what i want to do is fill in from a2 - a14 with what is in a1 and a16 ti a22 with what is in a15 my main prob is this goes on to a42675 hope someone can help me
Name: Grok Lobster Date: November 2, 2005 at 12:54:18 Pacific
Reply:
Well, I can do it in column B - I hope that will work for you. In B1, enter =A1. In B2, enter =IF(A2<>"",A2,B1). Then put your mouse cursor over the lower right corner of B2 so the cursor turns into a small black + instead of a block white +. Click and drag to the end of your data in col A to finish. If you like, you can select all the data and do a copy/paste special (in the Edit menu) and choose paste values to get rid of the formulas.
0
Response Number 2
Name: mom Date: November 3, 2005 at 10:50:58 Pacific
Reply:
thanks worked a treat you saved me hours of work thanks again
Summary: you could also use this formula in column C =IF(OR(B1="",BE2=""),"",(B2-B1)) it says if cells B1 or B2 are blank, insert blank in the current cell otherwise subtract the contents of B1 from the conten...
Summary: I think I get it. A1=20%, B1=80%, C1=100%. D1=20%, E1=80%, F1=100% A3 = 62, B3 =12, C3=74, D3=66,E3 =18,F3=84, You need to check row 1 to see if it's 100% then check row 3 to see if it's over 64. H...
Summary: Ok, I understand that in Excel, to convert a string of texts to all caps could be done by using the UPPER formula ( e.g. UPPER("Text") ) My supervisor came to me and asked me, she has a column full o...
0 
WPD to DOC
