# Forum

Search
Close
Results 1 - 50 of about 89
• ## Finding MAX value with criteria list [Solved]

Those wanting to use this for MIN you have to wrap this in an IF to check for ZERO =MIN(IF((\$T2:\$T9=1)*\$S2:\$S9>0,\$S2:\$S9))

• ## How to convert Date of Birth to word in Excel

http://ccm.net/forum/affich-899537-date-of-birth-into-words

• ## Date and If function

What are the conditions?

• ## Add "x" years to date when it has certain words

As is typical, we'll probably never know.

• ## conditional Formating question [Solved]

Select cell B1 then add the rules below. For the Green: =COUNTIF(\$B\$2:\$B\$7,"Yes")>=4 For the Red: =COUNTIF(\$B\$2:\$B\$7,"No")>=4

• ## Excel formula question.

Sorry Luc I was fixated on the formula rather than the data. I found a similar question here and while it does not actually solve your problem...

• ## How do you make a VBA function in removing a specific value in a

Did the code work for you just as I posted? You mean you get an error when you type in like this: fndList = Array(":=", "#,") This...

• ## IF formula with dates [Solved]

CeskyWater, =IF((B2-A2)/7>12,"Greater Than 12 Weeks","") Where A2 is the Start Date and B2 is the End Date. B2-A2 gives the number of...

• ## EXCEL, If column terms match text In range b equal to or less th

Glad you are almost there. Fuzzy matches are always the easiest to do. Since you have done most of the work, you can have the coffee instead. :)

• ## A1 draws amount from other cells by live date.

I was right, didn't need all that other junk in there: This works just as well. =VLOOKUP(DATE(YEAR(NOW()),MONTH(NOW()),1),\$A\$2:\$B\$13,2,FALSE) ...

• ## multiple options for if in a drop down menu

Show me what you have.

• ## vba copy data from a range and paste to empty column

The macro works just fine as it stands and is doing it correctly. This line: NextCol = Worksheets("PNL").Cells(6,...

• ## VBA Using subroutines - help please [Solved]

The sample data doesn't seem to reflect the ranges chosen and the locations of the data pulled look like it overwrites the data in the...

• ## Excel Query

yes. That's what the formulas I gave actually do. The DAY function returns the DAY of the month from the date in the cell. So if...

• ## If, and question

Assuming the layout of your page is like this: Activity Percentage Date Plumbing 10% 1/1/2015 Slab 20% 2/15/2015 Shingles 45% ...

What macro?

• ## Data consolidation

and that's why it should be used. "It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on...

• ## I want to build intelligent excel [Solved]

in the 3rd column: =if(A2="X",A1,"") drag this down the rest of the rows

How much do each of the products cost?

• ## make in to single row in exce;

With your data in columns A, B and C. In D1, =CONCATENATE(A1,B1,C1) Then in D2: =CONCATENATE(D1,A2,B2,C2) copy this formula down through the...

• ## Sum values from one column if another column equals x [Solved]

Put this in a column other than A or B as you will get a circular reference error. =SUMIF(B:B,"X",A:A) Hopefully that works. I've not had a...

• ## Worksheet_Change event

ok, well then I don't have a clue what's wrong as each version I have posted works.. Please post the worksheet to SpeedyShare or somewhere...

• ## Subtotal

So if you hide row 42 the subtotal (i.e. the sum of cells in row 42) doesn't change? Is calculation set to Manual? This is the only way I get...

• ## Tell excel where to look [Solved]

Ok, so in J2 you type "November" Then in another cell say, A2,you type "J2" To return the contents of J2 referred to by A2, in another cell type...

• ## Excel: If Date =, then enter a value [Solved]

Brian is correct that you really shouldn't need to be entering hard-coded dates into formulas. To achieve what you need. 1. Create a new sheet...

• ## Finding Customers Names

The format and name boxes will not help you find contents of a sheet. However ,the Find box will, at least it should. So, we have a few of...

• ## greater than and less than

You cannot put the result, "Centimeters", in the same cell as the source. The formula must go in another cell. Either of these will do what...

• ## How to change word in cell using another word in another cell [Solved]

The cell is likely formatted as TEXT, change it to GENERAL and try again.

You mention 'certain information' but you don't specify what information. This should replicate the MasterSheet to the SubMaster sheet so...

• ## Match two unique criteria, total from a third .add to new sheet

Have you looked into the use of Pivot Tables and Pivot Charts? There is no need for the use of formulas. Here is the data you provided and the...

• ## script which can check if a debit has a corresponding credit [Solved]

I found a couple of issues (bugs) that I have now corrected. 1. diff is now a Double variable type. 2.The comparison of the cell location was...

• ## Using a comand button to open an external software? [Solved]

1. Yes. You need to enter the folder location and the executable of the program you are trying to open. As another example for you: C:\Program...

• ## Auto-running macro when cell is changed.

Try this version. Only a minor modification needed to be made to vcoolio's original code. Paste this VBA into the D5 sheet. Private Sub...

• ## Compare on a condition and Highlight the Difference

Comparing records like you need is reliant on the data in the fields being EXACT matches. For example, street addresses like "123 Smith Street"...

• ## A strange Range question ... [Solved]

Brian, I do remember this. I cant remember if thought the solution we ended up with or the reason it had to be done that way was clumpy/clunky...

• ## Changing cell color with either conditional formatting or macro

you can upload to www.speedyshare.com and post the link to it here. Curious though, did you try my suggestion? If so, did it work? Can...

• ## the DATE that i enter the DATA

I found this after a very quick Google: http://stackoverflow.com/questions/9311973/automatic-date-update-in-a-cell-when-another-cells-value...

• ## Need help with date and if statement newbie [Solved]

Nice. I have never used the EOMONTH function before. This version is tidier. =IF(DAY(C3)

• ## time calculation (TimeXnumber) [Solved]

The number of hours needs to be converted to decimal hours so that the calculation can work.

• ## How to replace * with / in all formulas in an excel sheet [Solved]

Is the dialog box rejecting it or is it simply not finding it in the sheet? BEFORE: AFTER:

• ## How to save a data excel to non data spreadsheets to excel

Please rephrase the question. I'm not sure what you mean.

• ## Shape not showing Text in excel

How you are actually adding the text to the shape? Simply clicking on the shape you have added and typing text should work.

• ## conditionally copy columns [Solved]

Could it be a simple as this? =IF(C2"",C2,B2) Put this is D2 and drag it down. Bear in mind that the column will still contain a formula,...

• ## Using one cell to refer to many

I would suggested leaving the date in per row as this makes thing far, far easier to analyze data. Once all the data is in place then it can...

• ## Conditional formatting with range [Solved]

Thanks to rizvisa1 for the solution to this: http://ccm.net/forum/affich-444020-conditional-format-match-range

• ## Change a range dynamically - VBA script. [Solved]

I think this is what you wanted. Not positive though. It all seems a bit clunky to me. There must be a better way to do this. Hopefully I have...

• ## Looking for help with a macro/vba for find/copy/paste

This code should do what you need: sqlstr = "" sqlstr = sqlstr + "select distinct left(part,instr(part,'.')-1) as part2, " sqlstr = sqlstr...

• ## If function date problem

Note sure which day you are using, Wednesday or Thursday? Anyway you can use the WEEKDAY function to return the day number: ...

Recommended

DON'T MISS

• Internet

• Video games

• Video

• Video

• Internet

### Instagram for PC

• Office software

• Security

• Internet