• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Microsoft Excel Security Warning

    Thanks a ton !! It's now butter smooth :DD
  2. M

    How to format cell based on the previous value in the same cell

    Hi, I have an excel sheet (2013) which is linked to website and streams live data. Let's say I currently have "XYZ" text reflecting in cell B15. After 10 minutes the data at the website changes to "ABC" and therefore the cell B15 is now reflecting "ABC". I have about 50 cells like that and I...
  3. M

    How to get list based on data validation

    Thanks a lot guys !
  4. M

    How to get list based on data validation

    Hi - Here is a problem I'm facing in creating a dashboard. I have Project's name in column B and have further teams under it listed in column C (number of teams varies for diff projects). I have created a data validation list in CD2. What I want it is - if I select a project name in that cell I...
  5. M

    Drop line automatically at the crossing of 2 line graphs

    Hi All, It could just be a simple trick but I'm having hard time trying to figure out where this is in excel. I have a 2 line bar graph which changes everyday based on the new data. What I want is to drop a line/arrow (like shown here http://prntscr.com/7m8meu) wherever the 2 lines cross each...
  6. M

    Two pivot tables in same worksheet..is this possible?

    Hey KiKi, yes, you can do that. While creating the 2nd pivot table, select "existing sheet" and then reference where you want to create. See the screenshot below for a test I just did :) http://prntscr.com/7fzurt http://prntscr.com/7fzvue
  7. M

    Conditional Formatting Issue

    Good enough Somendra.. Thanks a ton !! Will try to implement this one.. ! :) Thanks again !
  8. M

    Conditional Formatting Issue

    Thanks.. ny other way to do that apart from conditional formatting. May be like pop up some message in some other cell when value falls in the range and keep the msg stored.. or something like dt.. (thinking) :)
  9. M

    Conditional Formatting Issue

    Found the formula... thanks to Chandoo... he has explained in a thread =AND((A2>=(B2-B2*5%)),(A2<=(B2+B2*5%))) Now in need of a way to keep conditional formatting intact after the match is done (as explained in the above post)
  10. M

    Conditional Formatting Issue

    Thanks Khalid but this doesn't seem to work :( see what I want is.. lets say my B2 is 500 now when I get a value anywhere between 475-530 (which is 5% near up or down), it should color red. 2nd requirement is once it has fallen within 475-530, the color should stay red even if later it moves...
  11. M

    Conditional Formatting Issue

    Hi, How to store the conditional formatting when a criteria is matched. e.g - I have cell A1 where the value keeps changing. Now criteria is that A1 value should turn red when it reaches near 5% of B1. Also, once it A1 meets the criteria, the color condition should remain even after the value...
  12. M

    Web Query Error..

    yeah.. dtz the problem. It seems to be working in other computers. I tried opening in safe mode as well. But really hv no clue why it is happening. I'm guessing it could be coz of some issue wid internet explorer browser but dnt know wht.. tried resetting etc. :(
  13. M

    Web Query Error..

    Yes, I'm able to. Tried some googling last night & tried a few things. still it continues. Whenever I do refresh, it simply takes forever or just hangs (not responding) and I have to close it using task manager. Attaching the test file - Sheet 3 & 4 has the connected link data. (there are 2...
  14. M

    Web Query Error..

    Hi All, I'm stuck with a serious problem and have tried like 10 things to get this sorted out. Some one plz help. :( I have many excel file set up with web query which fetches data from various websites. For last few days, the refresh is not working.. it takes forever or it hangs. For testing...
  15. M

    How to reverse a string in Excel

    Why not try kutools. It has simple "reverse text" addon
Back
Top