Excel Help Need !!!!!!!!!!

L_Kaan

Well-known member
  • Aug 23, 2017
    1,053
    502
    113
    🚛 ලොරියේ 🚛
    Mehemay machan mama value past karala ne, mokada mata formula eka thiyenna oona data feed karapu gaman auto update wenna. formular eka thiyenddi kohoma sort kalath enne ara vidihatama thamay....:(:(

    https://imgur.com/yeynsd2

    mata oona "StorageBin" set eka system report ekakin aran methanata paste kalama, X1 X2 X3 X4 kiyana column set ekata bin number eke meda iri keella nethuwa kedila yanna oona, ita passe X3 kiyana column ekata A-Z sort kara ganna puluwan wenna oona....

    Kohomada karanne.... (Value past karanna be mata fourmlar tika thiyenna oona)


    Image eka upload karanne mokenda ban........:confused::confused:

    https://trumpexcel.com/sort-data-in-alphabetical-order-formula/

    meka poddk balapan..
     

    rangawkrs

    Well-known member
  • Jun 26, 2017
    367
    57
    63
    DATA - TEXT TO COLUM - NEXT OTHER -

    Z1 1 10 3 Z1 1 1 1 Z1 1 11 1 Z1 1 20 2 Z1 1 2 1 Z1 1 3 2 Z1 1 33 1 aye add karaganna onanan =CONCATENATE(
     
    Last edited: