User Profile
Mojibure
Copper Contributor
Joined Mar 09, 2022
User Widgets
Recent Discussions
Re: Formula Correction
Rodrigo_ Thank for the reply. I have attached the snip for scanerio. What I want is sum of column B on the basis of column C for each lebel of column A like for 123000, 87900 & 99800. For info: here I have created only one pivot table but we have multiple pivot table like this below. If you can frame any other formula that would be helpful or great if we can fix this one.1.6KViews0likes0CommentsFormula Correction
Hey Everyone, I am trying to apply one formula but it's giving me no results. Can anyone please correct this formula? Here is the formula =SUMIF(CONCATENATE("E:E",MATCH("ABC",A:A,0)),"T90",B4:B12) This part "CONCATENATE("E:E",MATCH("ABC",A:A,0)" separately giving me range which I wanted which is a range for sumif but when I am trying to insert it in sumif it's giving no output. Thanks in advance Rehman1.9KViews0likes6CommentsHow to tweek table array in Vlookup function
I want to apply Vlookup but lookup value is 314-645 and table array's first column has value GHJ-314-HTY-645-KPU Now how can I tweek table array'first column data in formula itself because I cannot make change in table array sheet. This is use of very frequently so this takes lot of time if i copy table somewhere else and make changes into it. Please suggest solution Thanks in advance.Solved927Views0likes2CommentsHow to tweek table array in Vlookup function
I want to apply Vlookup but lookup value is 314-645 and table array's first column has value GHJ-314-HTY-645-KPU Now how can I tweek table array'first column data in formula itself because I cannot make change in table array sheet. This is use of very frequently so this takes lot of time if i copy table somewhere else and make changes into it. Please suggest solution Thanks in advance.
Recent Blog Articles
No content to show