Related Posts
Johnson & Johnson Mondelēz International I am working as a Territory Manager with Cars24 from around 11 months and in total of around 6 years of working experience as a Team Leader. Data Management # Channel Sales # General & Modern Trade # FMCG # New Product Launch # Marketing & Finance. Looking out for a organisational and cultural change to enhance my productivity and learning.🙏Britannia Industries Limited ITC Limited Johnson & Johnson Nestle Dabur India Colgate-Palmolive Pepsico Marico Hindustan Unilver Limited Mondelēz Internatio
Please like so that i can dm others thanks
Fishes please like my post so that I can DM
Additional Posts in Excel Genius
I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?
What are the most typical models you all build
New to Fishbowl?
unlock all discussions on Fishbowl.
@Assurance Senior 1: say you have data from A1 through A469. I would just highlight that data in that column in full (A1:A469), Go To Special—>Blanks, then in A2 do =A1, and hit Ctrl+Enter. It should then fill all of the GL Acct numbers for you using the ones above it until it changes.
@kpmg1 I hate to admit it but I think OP has me by a bit in the knowledge department but for how I got to being the most knowledgeable excel user in most rooms it was entirely self taught through mostly side projects I was doing in college mostly to do with sports statistics or other dumb hobbies. It's probably slower than a course, but you can learn a ton just by googling and becoming familiar with the terminology as you're working and realize you need to do something that seems like it should be possible
I can try. If you have a chessboard and can remember how the horse piece can start a move in the game - 2 steps vertically and 1 horizontally and reach a specific point in the board thats what an index match does for you. The match determines how many steps vertically and how many horizontally you can move and the starting point is always top left of your range (chess board). =Index(range,verticalmatch, horizontalmatch).
*Remember the words though- match returns a reference and not a value which is very powerful
Associate 1- =hyperlink("https://turbotax.com/","click here") enter this in an excel cell and click it
PWC1 - Its better done using VBA. For i=1 to inprange. Columns. Count: for j=1 to inprange.rows.count : if inprange.cells(i,j)<>"" then outputrange.offset(ctr)=inprange.cells(i,j):ctr=ctr+1:endif : next j: next i
BDO1 - I beat you to it. 1-1 so far :)
Alt N V T but you are asking just to annoy me. Give me a formula thing young kid.
@a1 =left(1, text(year(cell)))
I think I was pretty clear that I want to use whatever word is in cell A1 (in this case January) to pull from a tab with the same name.
@KPMG 1 - you’re on the right track, you just need to add another MATCH function for the column. So you’d have =INDEX(SourceInfo , MATCH([GL Acct #],A:A,0) , MATCH([TB Code],1:1,0)). SourceInfo is the table basically where all of your data is, GL Acct # is the account #you want to find (normally a reference), and TB Code is the code # you want to find (normally a reference). A:A and 1:1 assume your rows and columns are in the first and top rows/columns but you can replace with wherever the GL and TB #s are
I was neck deep in work today but 2-1 it is.
Officially my favorite 🐠 thread
Is there a formula or function that can align data in the same column vertically if it’s all over the place? Like I have a TB that has account names in various columns from A - E and I want them all to line up in the same column without having to cut and paste a bunch of times if that makes sense
Parse out the first number after the second “/“ for a column (let’s say column A, rows 1-10) of dates formatted in MM/DD/YYYY
You can use =indirect("January!A1")
Where did you learn all this?! Time or actual course?!
Short cut for pivot table?
Formula to take the GL numbers above and paste below until another GL Number appears and for it to repeat
@a1 or text to columns fixed
I think you’re looking for the INDIRECT function @PwC 3