sally

Hi, can anyone help me with this in Power Query? I'm trying to get data like this first table (Table 1) to look like (Table 2). I understand how to unpivot and pivot in Power Query (and it doesn't work here - I get an error with Sally's hobby) What I don't understand is how to go through and...

<colgroup><col width="64" span="7" style="width:48pt"></colgroup><tbody> <tbody> Name jan feb march apr may june jack 1 2 3 4 5 6 sally 7 8 9 10 11 12 Girish 13 14 15 16 17 18 wen 19 20 21 22 23 24 </tbody> </tbody> <tbody> Name Jan to june sally...

Hi and thanks in advance for the help! I need to convert stock buy and sell requests into matched offsetting trade transactions. The Buys and Sells here are the inputs and the trades are the outputs. Answers in PQ are preferred but VBA or Excel are fine too. <tbody> Inputs Outputs...

Hi guys, I am fairly new to excel so I don't know very much. I have done A LOT of googling and trying to figure things out - and so far I have succeeded pretty well. However, there are 2 things that I can't seem to find the answer to (and honestly I have a difficult time understanding some...

I have employee names and accumulated points in column L The points are in the row directly below the name. I have a macro that will display the name in column M and the point total in column N once the value hits 2 or 3 or 5. I would like to automatically generate a separate email every time...

Hi, Please help me, i'm not very good with excel. My scenario is I have 3 columns of names. I want to look at the first name column (which is my source of truth) and see if the name exists in the other two columns. If the name does exist in all three columns, I want to return a "Y" value in a...

Hi Community! - I am needing some help trying to configure a macro/vba to trigger which email address to send to based on user selection from a Cell based dropdown list. Below is my code. I can't figure out where I am going wrong.. Essentially the macro should work as follows: If...

Hi, Is it possible for vlookup to return a cell greater than x but below y. two conditions. name (a1) and number (b1) Quick and dirty example below: vlookup(a1 and b1) return test1 <tbody> Sally 750 Bill Sally Dave 0 500 501 1000 test1 1001 1500...