pink

Hi, I have a set of data as shown below <colgroup><col><col><col></colgroup><tbody> Value Category Date Red A 3-Jun-19 Yellow B 8-Aug-22 Blue C 10-Jun-20 Green A 12-Dec-19 Black B 12-Dec-21 Purple C 5-Jul-23 Pink A 30-Dec-20 Brown A 21-Nov-20 Magenta B 5-Mar-19 Orange A...

I’m trying to accomplish the following: (my formula will bebased on a specific month, year, program name and look at a program descriptionto give me the year to date total.) I will have several lines with the same year, same program and same program description looking for the Year to date total...

Hi Guys Please could you help me to develop this solution in the Power Query. I believe I understand steps I need to go through or at least this is how I would do it in MS Access but not sure how to do it in PQ as I am really new to this. I especially struggle with Steps 4, 5, 6 1 Bring all...

Hi. I have a data set that is annual values for various colors. For each of these colors, in any year the value will be 0 or greater. For each year, I would like to have a cell list all the colors that are non-zero for that year. For instance, for the table below (apologies for formatting)...

I have a fillFormula macro, but I want to include something in it to 1) apply a conditional formatting to Range("C7:C" & Lr) that will look for duplicate values and apply a red-bold format to each, and 2) to set column C to a text format so that it will stop dropping leading zeros. Also, I...

I am being sent table in followoing format I want to lookup based on name and color. Do I use a vlookup with offset? Index and match? ColA COLB John Red 12 Blue 324 Pink 34 Paul Green 1234 Red 1121 Any help is always greatly appreciated

<tbody> Users Colors User 1 Blue User 1 Pink User 1 Green User 2 Blue User 2 Pink User 3 Blue User 4 Blue User 4 Pink User 4 Green </tbody> I have another table which has a list of users and I want it to say yes/no as to whether they have the full set of colors (Blue, Pink...

Hi I want to create a button i can click to hide all lines which are not green, yellow and pink. Or just show the lines which have no color. How can i do that?

I have tried autocalc, formatting to check for text, etc. Nothing works. I included link for workbook. Look on 1010 tab on cell s23 (pink area). when I click in and out of a cell, the return goes to 0 from a previously calculated formula. I'm totally lost...