LinkBack URL
About LinkBacks
Hi,
I'd like to change only all the times as C2.
Which formula could I put in B1?
Thank you very much
How to change all the times
Hi,
I'd like to change only all the times as C2.
Which formula could I put in B1?
Thank you very much
Last edited by Biscuits; 02-07-2010 at 03:44 AM.
It is not very clear which times you wish to change. Can you elaborate a little more?
Regards,
Karan
Hi Karan,Originally Posted by karan
In the attached xls, the time 00:01:13,083 --> 00:01:19,250 in C2 is the same to A2.
I'd like C6=A6, C10=A10....etc. (others not changed)
Thank you ^_^
if you want all 4th cells after C2 changed to respective cells from A, then see attached file.
when you click on RUN, it will make all C2, C6, C10.... etc. same as A2, A6, A10... etc.
Otherwise, redefine what you need.
modytrane
like this?
i did it by
1. in b1 put
=IF(OR(LEFT(C1,2)={"00","01"}),ROW()+6000,ROW()) and dragged down
then copied paste back special values
then sorted by col b
whent to first 6XXX row and in cxxx put = axxxx wher xxxx is row number
drag down to last value
copy col c paste back special values
in a spare cell put 6000
copied that
selected all 6XXX values pasted special subtract
select all colls again and sorted by col b
deleted contents col b
mind you probably easier just to
=IF(OR(LEFT(C1,2)={"00","01"}),A1,C1) in another column drag down then copy paste special over c and delete the formulas
Last edited by martindwilson; 02-05-2010 at 10:49 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Ok, I missed it. I didn't realize that it's not every 4th row.
I have modified the macro to look for "00:" as first three chars in column A.
see attached file.
modytrane
Another route might be:
B2: =IF(A2="","",IF(ISNUMBER(A1),A2,C2))
copied down for all records
Copy paste results as values over C2 etc...
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
DO,
I think you meant
modytrane
Please Login or Register to view this content.
No, I meant what I entered... the number resides in the row above (A1) not the current row (A2)... thanks though.
Sorry, DO;
you were right with
modytranePlease Login or Register to view this content.
Nice!
Thanks a lot, Karan, modytrane, martindwilson, and DonkeyOte ^_^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks