-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
smb
-
T
Help getting multiple rows of data from a selected drop down list...
I have the following rows of data in my sheet. Here's 7 as an example, but I essentially have over 1000 rows of data. <tbody> A B C 1 Account Owner Segment 2 Tesla Jess COM 3 Brookstone Kelly SMB 4 GoPro Jess SMB 5 Apple Linda ENT 6 Google Kelly ENT 7...- thp510
- Thread
- account jess list rows smb
- Replies: 8
- Forum: Excel Questions
-
T
Need help finding a result in a table (array? maybe simpler?)...
For Worksheet_1, I have the following table below across columns A to G and on rows 1 to 15 in excel. As you can see, it shows which person owns which segment (SMB, ENT, GROWTH, COM) based on their state. So for example the person that owns ENT in MT is Kelly (cell G3) or the person that owns...- thp510
- Thread
- ent jessica phil smb state
- Replies: 6
- Forum: Excel Questions
-
A
Newbie excel question
Working on IF logic . Does if take in range like (200-500) then x I tried writing this formula =IF(J2=(50-200), "SMB", IF(J2=(200-500),"MID MARKET", IF(J2=(5000-10000),"SME", "Large Enterprise"))) But it did not give me the required answer which was supposed to be "SMB" Any pointers?- avenkat
- Thread
- give ifj2=5000-10000 large smb sme
- Replies: 7
- Forum: Excel Questions
-
J
Matching cells and copying row between sheets
Hello, I need help with data on different sheets. On the main business unit sheet named for it's VP, Murphy, I have a list of employees in column A. On the shared mailbox sheet, I have a list of shared mailboxes (SMB) owned by different employees with the name of the owner (employee) also in...- juliat2
- Thread
- column murphy row shared smb
- Replies: 5
- Forum: Excel Questions
