blue

:eeek: I thought that some of my other questions were weird... I have a large, multi-page spreadsheet with lots of tables & formulas (100's) Many of the formulas look-up data on the various tables & then return the next set of instructions: IF(A2="RED",[Do This],IF(A2="YELLOW",[Do...

Hi there everyone, First to mention, my knowledge and skills on Excel are really poor and going through some practice/research I got to a point I can't figure out a solution for this issue. So, I need to basically get what the most common word between some cells. I've checked many solutions...

Hello all I'm looking for a little help with a formula I'm working on <colgroup><col width="64" style="width:48pt" span="18"> </colgroup><tbody>...

I need the below to read White, Blue, Red & Silver. I have used the =SUBSTITUTE(B4," &", ",",1) to remove the first one, but I can't figure out how to remove the second &. Please help. TIA <colgroup><col width="64"><col width="203"></colgroup><tbody> ADJ4 White & Blue & Red &...

Hello, I would like to set up a formula so that it returns random rows from the below table. I would need to return the corresponding columns as well, for example if it returns the value in A4 it would need to return the corresponding value in B4, C4 and D4 as well. <tbody> Card Code Rarity...

Hey guys, I have a bar chart with two values for a given year and this done over a 5 year period. For example blocks highlighted blue will be ascending over time with amounts increasing each year and orange will be decreasing each year Can the difference between the total summed values for...

I have a table of which this is an extract: <colgroup><col><col><col><col span="2"></colgroup><tbody> design foreground background size type plain white black XL T-shirt plain white black M T-shirt plain brown yellow L cap paisley blue yellow L cap paisley blue yellow M T-shirt...

Hello, I am looking for a formula. I have one tab with raw data, multiple records, multiple duplicates, etc (tab named [raw]). I have another tab [Plan] where I need to insert my formulas. In my reference cell A1; I will enter a unique ID number. I want to use that value I entered in A1 and...

Hi, I need help. When I check a checkbox I want the text in listview to be highlighted in blue, I am having a problem where whenever I do check the checkbox the text does not highlight blue unless I move my cursor into the listview. Also whenever I check each individual checkbox in the listview...

I have a quite big spreadsheet with several tabs. The main tab is called "ratings" There are several named ranges inside the "ratings" tab with same names as names of other tabs in the spreadsheet This is the photo of the example named range inside ratings tab called "NorTL" Pls note...

Hello, I have a spreadsheet with two columns, one has an area name in and the second column has the branch name. Some areas could have 5 branches and some could have 15 branches. I would like to format each row based on the area name. So if its area 1 then say a light grey, if area 2 then a...

so i have a long number from a barcode. 0190027182300349320100024711190409210219892014g in cells a6-a460 where the 3rd #to the 14th is fixed 90027182300349 and want cell g6-g460 output text tied to that number so 90027182300349 would = to blue 90027182232456 would=to red I tried the...

Hi All I need to sort column A first by the lowest number. Column A is always a number.Then by Column B and is always a word with many duplicates. Example: Sheet 1 _____A______B 1____21_____Red 2____22_____Red 3____23_____Red 4____103____Green 5____104____Green 6____105____Green...

I have two tabs on my spreadsheet “green” and “blue”. Muchof the content is identical but has been sorted for numerous reasons. The blue tab is where my destination cells are and where theformula should go. I need a formula for P2 that looks at D2 and compares it toD2 – D120 on the green tab...

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

I am looking for the most efficient way to take a two column table of data and convert it into a multi column table of only unique rows based on the value of the first column (see simple example below). Can be a VBA script or formulas. I am working with data that starts at around 10,000 rows of...

This is my first post on MrExcel and I really need a hand... I have a multi team game log where the dates are out of order and the data doesn't contain who played who so each team must be handled independently. I'm trying to figure out win streaks and current streaks "for each" team (Should I be...

Hi I have a table and in column c I have cells which have black font and cells with a blue font. When the toggle button is pressed I want the cells which are black to remain black font and the cells which are blue to match their interior colour, in other words, they seem to disappear. The...

I am trying to identify duplication of words between cells and am hoping this can be accomplished with VBA Here is a sample of the input and output. I am comparing string 1 to string 2. String 1 String 2 Output red orange yellow green...

<colgroup><col width="64" style="width: 48pt;" span="5"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3072;"> <col width="64" style="width: 48pt;" span="5"> <tbody> Trying to use VLOOKUP to pull data from 2 or multiplearrays. Only kicker is that I usemultiple...