Search results

I'm sorry, at this time, my expertise is mainly in Excel Formulas and Excel functions like Pivot tables, Data Validation, Conditional Formatting, and other menu features, but not VBA. I am not sure, but possibly Data Validation may be an alternate for you. It allows users to pick from lists...

This solution involves only formulas and is good for any Excel version. This solution is based on inputting a category in B1 of Sheet2. In Sheet1, a new "helper column" is added with formula in D2: =IF(C2=Sheet1!$B$1,COUNT(D$1:D1)+1,"") copied down. This finds and counts the matches. Then...

No attachment.

Does this help? It is a user-defined function that you can use to extract hyperlink paths to your worksheet. http://www.ozgrid.com/VBA/HyperlinkAddress.htm

The ? is a wildcard character in Excel, it is used to denote any one character in a string. So when you try to replace ? with anything, then all characters get replaced. If you only want to replace the actual question mark, then precede it with a tilde (~ , key just above the tab key on a...

You can't do it with any of the format border tools, but if you are creative you can use drawing objects to overlay a rounded-corner border Here is an idea: http://blog.xlcubed.com/2008/06/creating-rounded-corners-in-excel-tables/

The default justification for the TEXT format is Left justification and the default justification for Number is Right justification. This is based on the tradition of have numbers right aligned so that they are easier to read and when using fixed decimals, you can align those decimals.. The...

As I mentioned in Post #4 above.

So, I am still not sure of the problem. None of the items in column D of Workbook1 are found in column P of Workbook2.... that is why you get #N/A error. Are there any that are supposed to match in those samples?

Nobody can test your excel formulas on a word document. Please post Excel sample workbooks only! (i.e. as .xls or zipped). None of the items in column D of Workbook1 appear in Workbooks2 column P... as per your sample... so..... what are you expecting here?

So you are sure you are trying to match D3 from your active workbook with column P of a workbook named Workbook2 and in a sheet named Sheet1 in that workbook? And you are definitely wanting to pull from column W? If you get N/a, then there is not an exact match. Something is different. It...

Try using a Vlookup formula. e.g with both workbooks open, in H2 of Workbook1 =Vlookup(D2,'[Workbook2.xls]Sheet1'!P:W,8,FALSE) Where D2 is first item in column D of Workbook 1 you want to search for in Workbook 2, Sheet1, column P and return result from corresponding row in column W of...

If you do a Find/Replace on those cells (CTRL+H) and replace (dot) . with (colon) : Then you should be able to format cells as TIME and select your desired format. If you want a separate formula, then try: =SUBSTITUTE(A1,".",":")+0 where A1 contains original text time.. and then format that...

If you are going to start in B1, you need to adjust the COLUMN(AC2) part because then it tries to include AC2 in the calculation giving a circular reference... Try: =SUM(B2:INDEX(B2:AC2,COLUMNS(B2:AC2)-1))

So, if I understand you correctly.... you have say A2:AB2 with weekly numbers and AC2 has the YTD total sum. Now you want to insert a column between AB2 and AC2 and have the new YTD total account for that inserted column. Is that correct? If so try something like...

If you can assign consistent cells in each worksheet with a tally of the respective sheet, then in the summary sheet you can use a formula like: =SUM('Sheet1:Sheet10'!X1) this would sum all the X1 cells from Sheet1 to Sheet10. If you will continue to insert sheets, then you can add some...

The formula I gave you: =IF(H65=A93,IF(OR($H$4="Complient",$H$4="N/A"),1,IF($H$4="Non Complient",TRUE,"")),"") will return a blank if H65 is not equal to A93, doesn't it? Also not sure why you need Vlookup to lookup one cell? You can use something simpler like =IF($A5=Adult!$D$4,A5,"")

It seems the forum added a space in my formula... should be: =IF(H65=A93,IF(OR($H$4="Complient",$H$4="N/A"),1,IF($H$4="Non Complient",TRUE,"")),"")

Yes, usually that is the easiest way. But I find we can never win the battle... when I suggest using helper columns, most OP's ask if we can do it without the helper columns.... and then the opposite, when I try to combine the result into one formula, the user finds it too complex and would...

I assumed you had the #N/A! error in H4 since VLOOKUP() would return that error if you have no match..... Anyway, if you have text string "N/A", try then: =IF(H65=A93,IF(OR($H$4="Complient",$H$4="N/A"),1,I F($H$4="Non Complient",TRUE,"")),"")