How can I divide every number of my 6x6 (or matrix of any order) by two.
I used 'grouping' but it select either row or Column field at a time.
Remeber I am not asking about Pivot table
Any Suggestions may lead towards result.
Regards
Sid
Store the excel file in a comma separated values (CSV) format, say, in X.csv.
I wrote a quick script for you.
Code:
set $wsep = ","
var string in_table, out_table ; cat "X.csv" > $in_table
while ($in_table <> "")
do
var string row ; lex -e "1" $in_table > $row ;
while ($row <> "")
do
var string column ; wex -e "1" $row > $column
echo makestr( int( makeint(str($column))/2 ) ) >> $out_table
echo "," >> $out_table
done
echo "\n" >> $out_table
done
echo $out_table > X.csv
The script is in biterscripting. (If you don't have it already, install from https://www.biterscripting.com/install.html. It's free.) Save the script in C:/Scripts/divide.txt. Start biterscripting. Execute
the following command.
Code:
script divide.txt
That's it.
Randi
(I do a lot of spread sheet manipulation using bscripting. If you need more help, email me.)
The easiest way (if I understand you correctly) is as follows:
Let us assume your table is in A1 to F6. Enter the following formula "=A1/2" in cell H1 and copy it from cells H1 to M6. Excel will automatically increments the row and column references in each of the target cells.
Alternatively you can use an "Array formula".
1. Highlight the range A8:F13 (where the result will be)
2. enter in the formula bar (at the top) the equal character =
3. then using the mouse, block the range A1:F6
4. continue entering /2 on the formula bar, which is obviously the divide by two that you want.
5. Then enter simultaneoulsy Ctrl Shift and Enter
and all 36 cells will be filled in.
I suppose this would be an opportune time to mention my book:
"Excel by Example: A Microsoft Excel Cookbook for Electronics Engineers" published by Newnes/Elsevier