Formatting data in scattered rows into rows following each other

MorneDJ · #3 12-09-2016, 07:36 AM

Those are just numbers I typed but the calculation is something along the line of ...

Imagine Column A is a filled with the measurement number (e.g. 1, 2, 3, 4, 5, 6, 7 etc.), with column B containing the numbers used to calculate the equivalent number, the calculation is something like for the first 3 values:

Code:

A      B       C
1		
2	84.9	
3	57	
4	30	80.1

Code:

x = (10 * log((1/(A4 - A1)) * (10^(B2/10)+10^(C2/10)+10^(D2/10))))

X = 80.1

For 6 rows it will be:

Code:

x = (10 * log((1/(A7 - A1)) * (10^(B2/10)+10^(C2/10)+10^(D2/10)+10^(DE/10)+10^(F2/10)+10^(G2/10))))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Embedded Excel charts refresh only data values, not which data points (rows) are included	GregL	Word	0	12-01-2016 10:24 AM
Delete blank rows between the two rows that contain data	beginner	Excel Programming	5	12-26-2014 12:29 AM
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM
Count rows and add blank rows accordingly	Hoochtheseal	Word VBA	1	01-29-2013 09:23 PM