returned

I have the following formula and keep getting a zero when I want a blank returned. Please help! =IF(AND($D$102>0,$D$36="Direct Debit"),"Direct Debit Acct" &" "&$D$102,$D$36)

I'm a bit stumped ... when I enter "0:00" into textbox 'cu2_end' .... etc_cu2 = CDate(cu2_end.Value) Debug.Print etc_cu2 I am returned the correct value for 'etc_cu2' which is 12:00:00 AM. How can I get the decimal equivalent returned for 'cu2_end'?

Hi all, Is there a way to use a formula but not as an array? =IFERROR(INDEX(Update!$BI$2:$BI$1000, SMALL(IF(COUNTIF($D$8, Update!$BG$2:$BG$1000)*COUNTIF(E16,Update!$AZ$2:$ZA$1000), ROW(Update!$BG$2:$BG$1000)-MIN(ROW(Update!$BG$2:$BG$1000))+1), ROW(A6)), COLUMN(A6)),"") this formula works...

I've taken on the role of organizing the weekly golf score for a group of guys. We have an excel sheet with some basic formulas and I wanted to take it to the next stage. I am trying to put in multiple IF and AND formula into the cells, but as I get towards fitting them all in it ends in...

I have a formula <colgroup><col></colgroup><tbody> =(A3&"."&B3&"@test.co.uk") which returns mike.crowston@test.co.uk I would like to copy the returned value to another cell <colgroup><col></colgroup><tbody> <colgroup><col></colgroup><tbody> </tbody> </tbody> </tbody>

Hi, the following formula works great until there is noting found in the index/match =IFERROR(INDEX('Details'!$C$2:$C$10000,MATCH(E10,'Details'!$B$2:$B$10000,0),0),"") Is there a way to show"-" instead of the "0" returned Many thanks

Hi I learnt how to use match() function. I have in a column 2 cells with the same value. When I tried to use match(), it returned to me the row of the first value. How that can be resolved? Thank you.

I have a formula that returns a number 1,3,4 with the following =IF(E3=D3,"",(IF(E3="R","3",IF(F3="R","4","1")))) I want to highlight values of 3 and 4 but I cant seem to get the conditional formatting to work. I have played with the format of the cells making them numbers, texts, general, etc...

All, I have 2 tabs. Tab 1 contains a column where I want the returned results to display, titled "Statuses." Tab 2 contains a column that could have just one of a numeric value (one number 5), or multiple (three number 8s). I want to lookup all instances of a number and associated TEXT...

Something like [=MEDIAN(ABS(C3:C20-MEDIAN(C3:C20)))] works but I can not find a way to define this statistic with a range of C:C so as to be able to see the change as soon as I add values? I thought that [{=MEDIAN(ABS(IF(AND((C:C<>0),(ISNUMBER(C:C))),C:C)-MEDIAN(C:C)))}] Would exclude empty...

Hi, I have a query regarding DartPart and the format of the value it returns. My example is using date 01/01/2018 If I use DatePart("d", #01/01/2018#) the value is returned is 1. However, what I would like is to have the value, if less than ten, to have a proceeding zero, eg 01. How would I...

Hi Guys, Im looking to use a macro to move rows from Active to sheet Returned based on the drop down menu wording in Row M.

Hello, I have an excel spreadsheet which is basically a message log. We are a paperless company so I made a spreadsheet which has an input page and 5 other pages - Monday - Friday. The input page asks for the Caller Name, Number and Details, it sends the info to the corresponding day page. On...

Hello there. I have 3 columns (A, B, C) based on which column D will have a result filled in (RETURNED VALUE): Columns look like this: A B C D (returned value) OK OK OK OK OK NO OK NO OK OK OK NO...

I have tried to set up a formula so that where the No. in Col J in the destination workbook is not on Col F on the source workbook, then "Account paid" to be returned. If the account No. in Col Jis found in Col F in the source data, Then "account not settled" to be returned It would be...

Hi All, In column A I want to check for "Liverpool Football" and in Column B I want to check for the words "Football" or "Sport", if this criteria is met I want "yes" returned otherwise "no", how can this be done? Thanks

Hi All, I have the following formula which looks for specific values in cells and if they are found a value is returned and if there is no matching value the cell is left empty, I want to change the empty cells to "n/a" is this possible? So basically all I want to do is put something in at the...

I have a set of data. First column is date (first of the month), second column is a yes/no on whether or not something was returned. Is there a way to plot this as a pie or circle chart and format so that all the "yes" values are one color and all the "no" values are another (without changing...

Hi All, I want to create a formula that will review dates in column A and if the year is 2017 I want the word "New" returned otherwise I want the word "No" returned. The dates will be in column A as follows, how do I code this? Jan-11-1983 Aug-14-2017 May-01-2011 Thanks in advance

Can someone please help me with a formula to do the following? I can't find any previous solutions. If a value from column A, features in any value in column C as the 3rd and 4th value, return the value from column B corresponding to the value in column A. Results being returned in column D...