heey people, probably a stupid question...
i got this simple formula: =B1&"M11"
in the next row i want: =B1&"M12"
etc, but when i grab the corner and drag it changes the B1 to B2.... etc
also, i noticed if i got M11 till M14 and drag it it will constantly go M11...M12...M13...M14...M11
is there a way to change this?
thanks in advance :)
Last edited by koqspijker; 09-15-2016 at 07:33 AM. Reason: solved
Hi, and welcome to the forum,
Perhaps
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thank you for your response, your formula does help me a bit, now it keeps B1 wel... B1
the "M12" etc is not a cell btw, its just text. sadly excel doesnt understand i want to count up, but atleast i dont have to change AND B# and M#
thank you very much, if you happen to know how to tell excel i want to count up with the "M#" please do
Try this ...
=$B$1&"M"&ROWS($A$1:A11)
im getting an error (#NAME?)
maybe becouse its dutch, ill try and look how to translate the ROWS in dutch.
EDIT: yup, that did it, this is the reason i hate to get my excel in dutch :p.
Thank you verry much!!
Last edited by koqspijker; 09-15-2016 at 07:27 AM.
You're welcome!
I want to the subtotal time by employee wise. but i can't do it. Please help me
@Sanjibghosh Please start your own thread for your problem rather than posting into another thread. To do this, go back to the Excel Formulas & Functions page and click 'Start new thread'. Once that is done I will answer you.
Thanks,
Danny
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks