pete

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...

I have 16,000+ rows in my spreadsheet, and over 100 names in column A. I need the total in column C to be cumulative at that point, not in total. For example, Anne at row 3 column C is 40 and not 60. If I sorted by A and B, smallest to largest, column C should be 20. Please help! Thank you...

Hi I have a long series of data that contains names in column A, Products in column B and quantities in column C eg: <table> <tr> <th>A</th> <th>B</th> <th>C</th> </tr> <tr> <td>John</td> <td>Apples</td> <td>7</td> </tr> <tr> <td>Steve</td> <td>Apples</td> <td>4</td> </tr>...

Hi Forum I am trying to simplify a roster spreadsheet for payroll. Sheet 1 Roster - job, staff and days working <tbody> Job shift hours mon tue wed thur fri job 1 0930-1800 sally bill tom bob sally job 2 0730-1600 bill sally bob pete bob job 3 0800-1630 tom bob sally tom pete job...

Hi, I came across this visualisation: https://powerbi.microsoft.com/en-us/blog/visual-awesomeness-unlocked-liquid-fill-gauge/ It is a great visualisation, but doesn't seem to work properly. On first loading, it shows % as % eg 101 is shown as 101. But if you filter at all 101% displays as...

This is probably very straightforward but its doing my head in, can someone help I have a worksheet which has two columns one with Names the other with value, all i need is a formula in column 3 that will return for each individual "lowest" for the lowest value attributed to that person and...

Good afternoon - can someone please advise as to how I can do this? Regards Pete

I'll do my best to phrase this - I have a table, see below. I have a table similar to below, in cells A9 and B8, I want to be able to edit the names to any of the names in the table, and have it return the appropriate value. E.g, If I change the names to Bob and Pete, it should show the value...