trying to populate columns F, G, H, I and JClosed

Question

I've attached a photo for some clarity.  

I am trying to populate columns F, G, H, I and J based on the info from columns L, M and D.  I've tried Pivot Tables and some formulas, just nothing yielding the results I need.  Any help is great.  Thank you!

ac3mark · Answer

Are you trying to parse the values in the other columns?

What info are you wanting in those?

does this help:
=if(logic_test,true, false)

So, you could:
=if(L1<>"","some stuff here")

I hope this helps, if not then give us more details about what you are trying to do, besides place some data because of some other data!

Have FUN!

longsa23 · Answer

First off - Thank  you for your quick response.  I am really green at this and just trying to figure it out with the help of Youtube and this forum.  So what I am a trying to accomplish is having columns F, G, H, I , J and K populate with a total number.  This number is aggregated from columns L, M and D.  L tells me the email, M, the email Domain and D the User Type.  Column F would give me the total times this email address has shown as an Admin/Manager.  G would tell me the total numbers of time as a USER.  H tells the total of F&G (I can do that one, ;)   ).  I, J and K tell me similar info for the domain.  Here is a screen shot of what it would look like if complete.  




Thank you again for any help!

Trying to populate columns F, G, H, I and J

2 replies

Subscribe To Our Newsletter!