nick

Hey i log information for my weekly work football and am trying to automate more of my collection of data. I have a set of data that looks like this: <tbody> <tbody> Date Game No. Win Draw1 Draw2 Loss Win Goals Draw1 Goals Draw2 Goals Loss Goals Win Scorer Draw1 Scorer Draw2...

Hi, I am struggling to filter Values in this example of a pivot table. I want to remove all channels from the pivot that are less than $100 in total not by country. i.e. when I apply the filter I should see some country channels line in this data that are less than 100 because that channel will...

Hello, I need some help creating VBA code where the cell color changes to yellow if an individual’s total for that particular month is over 100%. Here is a sample of my data: <colgroup><col><col span="2"><col><col span="12"></colgroup><tbody> Name Title Plan Notes Mar Apr May Jun Jul Aug Sep...

Hi All, Hopefully you can help with my problem. I am trying to calculate the number of points in one column based on the users name and the date by month. Example data is: Column A Column B Column C Name Date Points Nick...

Hi Desperately need a help to find two closest dates to today from the list of different people and dates. So the column C & D should show as follows. <tbody> a b c d e 1 Nick <tbody> 9/1/2016 </tbody> 1/1/2017 10/1/2017 2 Nick <tbody> 1/1/2017 </tbody> 0 0 3 Nick <tbody>...