return

Dear All! I've encountered a curiousity. A SAP download contains description within cells J to O. Both formulas, isblank and istext return "false". My goal would be to detect empty cells for deletion. All cells are formated manually as text and no value is shown when entering the cell...

Hello - I have a reference value that I'm looking to return the associated values into one cell but am not sure how to do that. For example, assume the reference value is MATH in worksheet 1 and in Worksheet 2 Math is associated with Geometry, Algebra, Statistics. I'd like to return both...

Can I use vlookup to search values and ranges and two sheets and return results to a blank sheet (Sheet3)? For example, sheet2 has a value in B2. Sheet1 has the same value in E2, but I want to return the value in A2 to sheet3. I want to do this is vba. If possible, any suggestions to get me...

I need this fix that if it has a date in the return column it will count it =COUNTIFS(List[Activity],Category1,List[Return Date])

I want that if Out Date column has a date, on the Status Column it will have the words OUT but when there's a date is Return Column it should say Return in the Status Column

This is what i have for example if in the Activity Columns it says AI Notices and the out date column have a date it should count it and when a date is added to the return date column the count come off because then it will be counted under return =COUNTIF(List[Activity],Category1,List[Out Date])

Hi, I have a set of data with a merged header cell, laid out like this: ---------------------------Merged header cell----------------------------------- <tbody> Value 1 Value 2 </tbody> I am trying to return Value 2, using the header cell as the lookup value. I've tried using HLOOKUP, but...

Hi I have read that if a function in vba returns something then it should be call using () for example functionName() I tried Date() which return a date but when I type it Excel removed () for me and my code look like this Sub mydate() MsgBox Date End Sub Why excel did not keep ()...

Hello. In cell B1 I have current date created with formula =today() eg. 26-Sep-2019. In the same column starting from cell B3 (B3:B600) I have dates and time in format dd.mm.yyyy - hh:mm (example. 20.09.2019 - 21:00). All those cells (B3:B600) are text cells. In column A there are...

Hello, I have an array formula that I want to update to make it more useful. {=(PRODUCT(1+$a$2:$a$28/100)-1)*100} That calculates the investment return for an entire time period, lets say 2006-07. I want to change the formula so that it will calculate the return only for the values within a...

hi i have this table: A B C A14 0-4.5 T54 4.6-7.8 U87 7.9-11.6 G65 11.7-18.8 Y56 18.9-20.5 F54 20.6-27.8 if the value to find is: 8.5 then I need return with a formula the value of column A, in this case: U87 other sample: if the value is: 5.8 the value that need return is: T54 wich is the...

Hello, Quick question. I am looking to do a multiple IF AND statement including LEFT. The below formula gives me a #VALUE error so I know I am doing it incorrectly: =IF(AND(C2="Blue",(LEFT(D2,1)="C"),"250",""),IF(AND(C2="Blue",LEFT(D2,1)="B"),250,"")) C2 has to be Blue AND D2 has to start...

So I have a table with a list of loads of different references with dates assigned to them and also 'yes' or 'no' assigned to them. I need to return the reference numbers if the date is in a specific period and they have 'yes' assigned. Example <tbody> Date Ref Status Jan-Mar 2019 & Yes...

I want to create a formula that can filter information. Right now I have the following formula: =IF($J$5=A:A,B:B) $J$5 is a date, and if that date matches the date in column A, then give me the text in column B. This is then pulled down for however many times that date is found, so I get...

Hi, i want to create a vba where i have a cell which when i put a value from a range it brings me back value in a cell that has a formula if from another range it yes . if it's no or blank don't bring anything. here is the example. Run the code and in column D if in B1 is Yes then put the value...

HI ALL, I'm planning to use some formulas to return my employee's schedule which looks clean and more simply from a complicated database. Here are what i have in the original schedule @ sheet_schedule for my 3x employee and a formula to return a concise layout @ sheet_result formula in...

Hello, First, I cannot use VBA for this; I need the spreadsheet to function within a sharepoint environment that doesn’t accept macro enabled worksheets. I am also very new to excel, but trying to progress rapidly. I am trying to create a single sheet within my dataset to return individual...

Hello all- Trying to cross reference one worksheet with another(old format) and return the relevant data that is in the left column if they match. HELP

Good day everyone, Yet again I have returned with an inquiry. I am trying to work on this sales file where I wanted to extract the daily sales. Here's the screenshot: (Screenshot below is just a part of a big raw file which contains over 6 months worth of sales data) Now, I was able to...

Hello, Need assistance with a formula to return the largest absolute value in a range and return the column heading in row 1. Found this formula on another forum and it works but it only gives me the largest value, not the largest absolute value...