Swipe Card Records Excel Spreadsheet

[leonardtan]

I have some swipe records but the move to row 30 instead of row 29

 

[Derek McGill]

What are you looking for ?

 

[leonardtan]

basically looking for a tweak in excel formula. when stride card the excel reads additional number and instead of cursor moving to b29 it moves to b30 due to additional info which is not required.

is there a way around this?

 

[Derek McGill]

You need to post excel code so it can be changed.

 

[leonardtan]

i attached an excel file

 

[Derek McGill]

No code on file showing move to row 30

 

[leonardtan]

normally we copy paste existing formula till end of sheet

 

[SirJB7]

Hi, leonardtan!
Could you please elaborate and describe how do calculate value in column I of worksheet data? I tend believe that "2A + 2C" means 2 adults and 2 childs, but I don't get how you obtain that result. Thanks.
Regards!

 

[leonardtan]

require assistance only on formula for column c. the rest are manual entry
scenario swipe card on card reader column b will appear reading the we use mid formula but due to the new card launch the card data has 3 additional data.

need assistance on formula for column c to remove the extra data when swipe as shown in the image attached

 

[SirJB7]

Hi, leonardtan!
Please discard my last comment, it was from another thread, copy&paste error.
Still I can't reproduce the behaviour that you described. Would you please upload the file of the printscreen of the 1st post?
Regards!