-
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.
$20
-
M
How to transpose data from one cell separated by commas
Hi All, I have a sheet from a manufacturer that tells me which models get which rewards. It looks like this... <tbody> MODELS REWARD X1245, J4541, Y4154 $15 A1015, N1522 $20 </tbody> In order for me to use v-lookup (as I have thousands of line items), How to I transpose this so that...- mikey15
- Thread
- $15 $20 model power query tranpose vlookup
- Replies: 5
- Forum: Excel Questions
-
S
Identify amounts that could be zeroed out
Hello, I have been struggling to try and find a solution to my problem. Or if there even is any. Basically speaking I have about 50K lines of data, within this list of data I have names and amounts associated to it: Example as follows : John $30 John -$10 John -$20 John $53 Samantha $20...- savosean
- Thread
- $20 data identify john samantha
- Replies: 9
- Forum: Excel Questions
-
J
Revenue sharing in excel to a certain value
Hi, Thank you in advance for helping. The company has a revenue sharing contract for 10% of the revenue starting when the company reaches $100,000 per month (month 7) in revenue until all $125,000 of the contracted amount of paid off (month 13) <tbody> Revenue <tbody> $20,947 </tbody>...- jasonvee
- Thread
- $20 company month revenue sharing
- Replies: 0
- Forum: Excel Questions
-
S
Merge cells based on duplicate values in adjacent cells
Hi I have a table as below: <tbody> 1 $20 1 $20 2 $30 3 $15 3 $15 </tbody> Now, I want to merge the cells in the 2nd column for corresponding duplicate values in col 1, as below: <tbody> 1 1 $20 2 $30 3 3 $15 </tbody> Regards Sabrez- sabrez
- Thread
- $15 $20 cells duplicate merge
- Replies: 4
- Forum: Excel Questions
