Hey guys im really dumb in Excel, I need some help.
First column is the item, then next one I have records for each, that is the stock. I’m struggling for an hour to find a formula which COUNTS how many rows are there, therefore I have the exact numb...
kuovonne:
IF({Field Name},
LEN(TRIM({Field Name}))-LEN(SUBSTITUTE(TRIM({Field Name}),"\n",""))+1
)
WOW , thank you so much. This really made my life easier :grinning_face_with_big_eyes: thank you so much
kuovonne:
IF({Field Name},
LEN({Field Name})-LEN(SUBSTITUTE({Field Name},"\n",""))+1
)
Ohh nice, thank you so much!!! It works now. Only gotta take care of not pressing enter after last record, because that counts as one too
kuovonne:
IF({Field Name},
LEN({Field Name})-LEN(SUBSTITUTE({Field Name},"\n",""))+1
)
Doesn’t work :frowning: what should I put in field name, based on my example above?
Its still not working :frowning: but thank you very much.
Also I checked that guide, but I still dont really get it. It seems too complicated. I would like to work on one table only. I think you understood what I was trying to do.
