brain

Trying to create a formula that will search column B for the number 69 and return the corresponding value from the same row in column G. Having a brain cramp. Thanks for any assistance!

Hello all, really racking my brain on this one. I go in these phases where I use dax a bunch, then dont use it at all and forget simple things I already learned. So here is a pivot table of some sales data. It is simply summarizing the 52 week sales for a store number, segmented within various...

I am trying to avoid using vlookup... That might be the most over used statement in Excel world. I have a sheet where I need the result if two criteria are met. For simplicity I'll try to explain below A B C NAME Date Total...

Hi folks, new member here from the UK. I've inherited a list which includes thousands of dates of birth However, the dates have been input in individual (Numeric) columns for each of Day, Month & Year (UK date style). I'd like to convert them into a single date field but my brain can't think...

Hi, When using conditional formatting in cells, if im showing an A grade and an A* grade I want them to show as different colours. I can't get conditional formatting to show them as different. Im sure its something really simple im not doing but my brain is fried today and i cant work it out...

Hi there, I know that the answer to this is staring me in the face, but I can't get my brain into gear this morning I have a range (I182:I186) which is reflecting dates from other sheets (date formatted 20180116). This range is formatted as TEXT as the reference cells are also formatted as TEXT...

Okay so this has been picking at my brain for sometime now... Can anyone help me out with this, here is what I have so far. "=if(C2,">=1","")HYPERLINK(B2))"

Hi All :) I have a cell (Y6) that returns a value: IF($K6="","",IF($K6>=61,DATA!$A$91,IF($K6>=51,DATA!$A$90,IF($K6>=1,DATA!$A$89,"")))) I have formatted the results in DATA!$A as I would like it to appear in the working sheet.: <colgroup><col width="682" style="width: 511pt...

Hey everyone, I am trying to get the following Nested IF Function to work, but my brain has a hard time putting the logic together. IF(D35<500,0,(IF((E35/F35)-1)<-.50,-.50,IF((E35/F35)-1)>.50,.50,(E35/F35)-1)) I am basically just looking to set an upper and lower bound if there are more than...

Looking to find the position of a character from the right hand end of a text string? <tbody> K:\02. Photos\02.04 Product Photos\ARCHIVE\2015 Product Shots\KPE 2015\ANIMAL SKITTLES.jpg </tbody> So I want to find "" at position 20 or -20 rather than at 3 I am sure it must be simple but...