one cell

Hi there. I've been struggling with a problem for almost a week now. I'm trying to assign a rank score to some data based on 3 criteria. The end result should be in a single cell (in fact, I'm using nested if statements to add different combinations, but this is the toughest one). Criterion 1...

Hi All, I am trying to (easy part) conditional format a column of dates to highlight past dates. <today()" <today(). Easy enough when they contain just one date, however some contain multiple dates - e.g. Column A <tbody> A = 01/04/2019, 13/03/2020, 13/03/2020, M = 06/12/2019 26/10/2018 A...

This is what I have I need this formula =IF(I5="M-S",IF(E5="W",WORKDAY(A5,-9),IF(E5="BW",WORKDAY(A5,-14)))) AND all of these in one cell =IF(I5="T-M",IF(E5="W",WORKDAY(A5,-9),IF(E5="BW",WORKDAY(A5,-14)))) =IF(I5="W-T",IF(E5="W",WORKDAY(A5,-8),IF(E5="BW",WORKDAY(A5,-13))))...

hello all, i have looked around and couldnt find an answer to my question so i thought i would try here. I am semi new to excel so please bear with me. I2 is the cell that needs to have the 2 different vlookups in it. Vlookup #1 will look at cell A2 (which is a part number) and if it is a...

I have a data such as below 01/08/2015 Apple 01/08/2015 Mango 01/08/2015 Orange 02/08/2015 Apple 03/08/2015 Orange 01/08/2015 Strawberry 03/08/2015 Mango 04/08/2015 Strawberry 05/08/2015 Strawberry 05/08/2015 Apple I wanted to insert a date in one...

Hello, I need to combine multiple product description texts which are in their own cells into a one single dedicated overall description cell which will encompass all the bulk texts from those separate cells, however not make all the text flow in single string without line breaks. Required...

Hi guys, Im stuck at what to do? I have a work sheet in which I have to base a response from L4 to highlight the appropriate cell C4. Such as shown in the image attached. Can any help. thanks

Hi, I'm new here so please be kind... So, I'm trying to create a calendar where I will have the whole month of lets say "April" and in one cell I need time in and time out separated by a comma, with one hour of lunch, which won't count towards the total of added hours for the day. It is easy to...

Hello everyone, Two if statements and text in one cell -- Excel or Access version: Excel 2010 Computer operating system: Windows XP Sample data: Excel WorkbookAB14Total of all segments* * * * * * * * * * * * * * * * * * * *279,33215Total of unique contacts* * * * * * * * * * * * *...

Hello everyone, This is my first post. I've used this web forum for almost a year now. It's really helpful. Helped me finish my MBA and helps me with my current positions as a data analyst for one company and as a business consultant for another. So, thank you. -- Hello everyone, Two dates...