In a coloumn i have entered starting from cell a10 to a36, and in a4,i have entered starting no as 1 end in a5, ending no as 245. i have entered the following formula to select the random no in b10 =IF(ISTEXT(A10),"",RANDBETWEEN(C$4,C$5)) but the result is not coming?
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.
Relative cell reference is address of cell , when copied from one cell to another gets changed automatically.
e.g. Put formula in cell c5 as A5+1 when you copy this from c5 to c6 the address of A5 will automatically changed to A6.
Absolute Cell Reference
As above now put formula in cell C5 as $A$5+1 ,now copy this formula from C5 to C6 if you this formula youwill find cell Address of A5 does not changed.
Mixed Cell Reference:
If we put Dollar ($) sign before Alphabetic cell address i.e.$c5 then even if you copy this formula in any cell , coloumn (c) will remains constant.
Similarly if we put Dollar ($) sign before Numeric cell address i.e.c$5 then you copy this formula in any cell row address of the cell remains same.(5).
Pl elobarate on remaining two points 'Specific order of formulas ' and 'advance formulas,
103 views
Usually answered in minutes!
×