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))))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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