Search results

That's right sorry, Points should change color depending on their value.

Hi everyone, hope you can help me on this one: I'm trying to color all chart series on my sheet according to their value. If negative, certain color, if positive other. So far this is what I have: For Each cChart In Sheet2.ChartObjects With cChart.Chart .SeriesCollection(1).Interior.Color...

Not sure exactly what your macro is doing, but if you are using Chandoo's hyperlink UDF the correct sintax would be: =IFERROR(HYPERLINK(MyMouseOverEvent("")),A1) And the UDF will print whatever's between the quotation marks to the defined Range on your module: Range("YouRangeName")...

You can also use Index and Match very easily to return the remaining info. Check here http://office.microsoft.com/en-us/excel-help/match-function-HP010062414.aspx http://office.microsoft.com/en-us/excel-help/index-function-HP010069831.aspx?CTT=3

That's right, but the user will select a "range of weeks", for example, Week2, Week3 and Week4 So you'll get an output range with the different weeks the user selected. So in this case, if user selected Week2, Week3 and Week4, the last value is 300.

Hi everyone! Tricky one here: I have a list of weeks, and for each an amount of employees. Like this: Week1 Week2 Week3 Week4 Week5 100 200 150 300 I have output values that can be multiple weeks, lets say Week2, Week3, Week5. I need to be able to fetch the last non-blank value...

Tried changing to Worksheets and it still doesn't work. And the chart name is always the same. I can't get it to work it's really picking my brain. Also: It's a private sub on the Sheet where the chart is (and not a module, though it doesn't work on a module either); it's set to run when a...

Hi everyone! Help! I'm struggling with the following code. It works fine until you open another workbook, then I get a run-time error saying this line can't be found Set cht = ActiveSheet.ChartObjects("Chart 19").Chart The full code is: Sub ColorChart() Dim cht As Chart Set cht...

Nevermind got it! Used named ranges instead of cell references :)

Hi! I'm using vba to filter a pivot table given specific values. This is probably pretty basic, but I can't get it to run if the sheet is hidden, or if I'm on another sheet. Here's the code: Sub Filter() Dim pt As PivotTable Set pt = Sheets(4).PivotTables("PivotTable2")...

I just saw the article and it's great, I'm planning on following that approach, counting groups of words that represent the sentiments and are associated with the concepts I'm looking to analyze. Thanks a lot Chandoo and everyone.

Hi Hui yes I was thinking on doing something of the sort, making the most out of the text functions. It's going to be a great challenge :)

Hi everyone. I'm using excel to collect opinions and I was thinking if there was something with the ability to do sentiment analysis built for excel, to identify positive/negative/neutral. I've checked and found some online services but they all charge for this service. Did anyone face this...

Can you post a sample file? Thanks

Try typing this in column F (I assume it's F1): =counta(A1:E1) It will count all cells that are not empty

Haha great! I'll be working on figuring that one. Thanks for the clue. VBA is just awesome

Its perfect! What if I wanted to have the option to select "All" in any of the parameters? So that it would have to ignore that column I guess? Thank you for your help, I've been having a huge headache with sorting text through arrays

Thanks a lot SirJB! Sorry I didn't post a sample file. What you posted is exactly what I had in mind. My only concern is, I was using a similar array formula, and I found that they struggle when going through a large dataset. And that's my case, I'm using thousands of rows and it takes some time...

Basically I'd need to create a new list, showing the text comments (those that appear on the row "Comment"), given that those comments meet 6 criterias. These criterias can be: Coca Cola, Europe, Italy, Rome, Boat, Part3. So a new list would be created containing only those comments that match...

Forgot to mention that it isn't actually filtering as it is creating a new list with the filtered data. Also, it's over 10,000 rows of data.

Hi everyone! I'm currently using array formulas to sort cells with text comments on them, based on criterias that appear on the 6 columns preceding the one with the text. It works, but it's really REALLY slow. I'm thinking if there's a VBA solution to make it run faster. Clarification: The...

That does it. Thanks a lot for the prompt reponse!

Hi everyone! I'm having an issue recreating a code I picked up from somewhere in the web. What it does is filter a table according to certain criteria, and there's a 2nd sub that restores all the information. The problem comes when I hide the sheet that has the data, and macros don't work...

Assuming the number "5" is in A1, this would work: =CONCATENATE(A1-4," ",A1-3," ",A1-2," ",A1-1," ",A1) You can remove the " " if you wish to have no spaces between each number. I think that's what you requested

Yup that was it, replaced the criteria with an IF and that condition. Thanks!