S
Steved
Hello from Steved
Firstly I import Data into three Columns
Col A = Start of the month to end of month (217 Rows)
Col B = Day ie =TEXT(a1 "ddd)
Col C = Data ie 34779
Each Day has 7 cities of data
Col E Sun,Col F Mon,Col G Tue,Col H Wed,Col I Thu,Col J Fri
Col K Sat as row headings.
ok I can use Vlookup Function for the first City and then
use Offset Fuction for the following 6 cities for each day.
I want to split the month into 4 weeks their lies my
situation, how do I right a Formula for this or is it
possible to be done in a Pivot Table if so how.
Thankyou.
Firstly I import Data into three Columns
Col A = Start of the month to end of month (217 Rows)
Col B = Day ie =TEXT(a1 "ddd)
Col C = Data ie 34779
Each Day has 7 cities of data
Col E Sun,Col F Mon,Col G Tue,Col H Wed,Col I Thu,Col J Fri
Col K Sat as row headings.
ok I can use Vlookup Function for the first City and then
use Offset Fuction for the following 6 cities for each day.
I want to split the month into 4 weeks their lies my
situation, how do I right a Formula for this or is it
possible to be done in a Pivot Table if so how.
Thankyou.