exclude

I am trying to create an IF formula as follows: =IF(A1>0,b1>0,A1+B1, "") So I want if to return anything above 0, and then add the two columns if there are numbers, but exclude blanks. I hope I am making sense. Not sure if the brackets are correct. Any help would be great.

[/IMG] This is an example of a formula I would like to house in the AD4 cell that will count only the cells that contain the following number/”C” combination such as: 0-9C 10-99C 100-999C I would like the formula to exclude the “CO” code along with values that do not have a "C" on the end.

I have two fields: one called Amount, and the other called Description. The description criteria has something like: Not Like "*TEXT2EXCLUDE*". However, there is an exception to the criteria above, which is do not exclude if >30000000. What's the approach to this in Access?

I have a table with a column of text values and a column of tables, <tbody> Value I Want to Exclude Column of Tables one Table two Table three Table </tbody> For the "Column of Tables," those tables will contain a column with values corresponding to the "Value I want to...

I'm learning as I go with Excel, and can't get my head around how to write this formula (if it is even possible). I want to count the characters in a cell, but exclude certain characters (plural). E.g. coding and spaces. I know how to count the characters and exclude only spaces...

I would like code to exclude updating links in certain cells if possible where text "GP%" and "Net profit achieved" appears in Col A , then the formulas in the same rows as these must not be updated

Hi, Is there a way to create a list of randomly generated names sourced from Column A that also excludes names in Column B without any duplicate names in the newly created list to be created in say Column C? Thank you

I'm writing a formula to sum up revenue data with an additional criteria or two. There are pay types which I want to exclude. Let's say that I want to exclude any paytype which includes the word "Apple" in the label. That is, I might want to include "Check," "Cash" and "Credit," but exclude...

Hi, I have an excel with start date and end date, and I want to only include working hours in the calculation of the difference. Currently I use NETWORKDAYS to exclude weekends and holidays, but How can I also exclude any hours that are not between 8.30AM and 5PM? my time is DD/MM/YYYY HH:MM:SS

Hi Guys, I was just wondering if anyone knows how to exclude UK Bank Holidays from Networkdays? ideally using a formula or select case? Many thanks Jamie

Hello, I've tried to modify an existing array formula that returns a list of all Projects meeting the "Yes" value on another sheet (Input) to exclude any lines that are duplicate. I can't get seem to get the modified formula right with regard to parenthesis, # of arguments, etc. Any help would...

Hi everyone, I'm working on a final piece to my puzzle, for now, and that is to certain data from cells in one worksheet to format another worksheet for a CSV file that will be used for creating DHCP reservations. What I'd like is to export only data from my worksheet called, "DHCP", that...

Hello, I have this line of code that sort of works: =SUMPRODUCT((DB!$J$4:DB!$J$161+DB!$K$4:DB!$K$161+DB!$L$4:DB!$L$161+DB!$M$4:DB!$M$161+DB!$N$4:DB!$N$161+DB!$O$4:DB!$O$161+DB!$P$4:DB!$P$161+DB!$Q$4:DB!$Q$161+DB!$R$4:DB!$R$161)*(DB!$H$4:DB!$H$161=DB!$AB$1:DB!$BW$1)*(DB!$B$4:DB!$B$161=A4)) The...

I am using Excel 2010. I have a CSV file which I opened in Excel. It has a lot of data in it. I have to exclude specific data from it. For example: I have a bunch of zip codes, and I need to exclude the ones that end in 3, 5, or 7. I have tried the advanced filtering option to no avail. I have...

I have a CSV file which I opened in Excel. It has a lot of data in it. I have to exclude specific data from it. For example: I have a bunch of zip codes, and I need to exclude the ones that endin 3, 5, or 7. I have tried the filtering option to no avail. I have to display the zip codes that do...

I have a spreadsheet that I open, selected a directory, and it gets files that are going to be put through a GIF creation process and a rename process. The problem is that there is currently no filtering applied in the code. I am a bit of a noob but can understand very very basic vba, just...

This shouldn't be hard, but it's giving me fits. This code is working well and I'm creating a collection of textbox controls so that I can detect changes on the userform (to prompt a user to save their work). I want to EXCLUDE one textbox (that I'm using as a search feature) from the...

Hey everyone, In column 'G' I have set up a 3 point colour scale based on the date. I want some of these cells to be excluded from this calculation based on the corresponding cell in column 'E'. So the rule I'm trying to create should go something like this: If E5 = "Action Taken" Exclude G5...

I have been trying to determine how to search matching values in a column and return another column's value on the same row into a concatenated string, excluding the data in the second column from the string in the third Using =Lookup_concat(A12,'other-finishes'!$C:$C,'other-finishes'!$A:$A) I...