Search results

ok, really appreciate your efforts NJ

Guys any help will be appreciated....

you have already gone through the example in the other post on the web, now what i was trying to get as you mentioned that once the values (eg: percentage) should change on a particular cell then it would show a different gradient based on the conditional format chosen. We can make the bars on a...

Any One!!!!

Guys any help will be appreciated....

THANKS AGAIN, WILL COME BACK IF ANY ISSUES...

Hi There I Have a series of data either horizontally or vertically, and there are values ranging from 0 - whatever value. the cells are conditionally formatted to show a gradient based on high or low values in the series.... now can we have a bar chart which can Automatically Set Chart Series...

thanks for such an excellent explanation, question; can we use the CHAR() Function to do the same instead of finding the quotes >> FIND(CHAR(34 OR WHAT EVER),A3)???

that was neat, can you elaborate on the code a bit (what it does) and also if there are more than 1 pair then would it take the first pair or the next or the last???

That did it Guys... That was a neat trick which i have been trying crack my head against. one more in the same sheet, how to get the data within the quotes and trim anything that comes before the quotes and after the quotes. Appreciated.

OH oh! revenge of the bad data format... just when we were getting it right this is what happens down the line 5.8 Feature film "Street of Newton House, 1" >> issue when the number of characters for the time is less than 4..... (replace the cell with this data and check) it...

ref topic http://chandoo.org/forums/topic/date-and-time-issue?replies=11#post-13747 thanks guys

ALL THOSE COLUMNS WERE NOT REQUIRED THEY WERE JUST THERE TO TEST DIFFERENT FLAGS..... Thanks there again, they worked just fine... I have more issues with some other files... Will keep posting and with you guys around may be i'll gain some excel expertise.. Appreciated...

Here is the link you can d/l the file, all data manipulated to keep real data safe. https://docs.google.com/open?id=0B5jCQSsK1WJ9ZGJjZjUxMDgtOTQyZC00MDM2LTljN2MtNmQ4YjMzOWMwN2Zj no login required Appreciated

Hi Guys Any News??? NJ

Hi Narayan Yes you are right that logic works fine, except when your time crosses midnight for instance midnight occurs at 00:10 am, now the next time that comes up in the next cell would be something like 00:15 or 00:25, then that logic is not useful as it will calculate those values as...

Thanks again Actually my excel experience is not that good when it gets to logic but at times we are forced to come up with things to get things going and make them work, as can be seen from the formula used for the time conversion as well as the date. Now would you be nice enough to put...

HI there As you must have read the previous post, Luke and Fred did a good job there, But then every other scan we get have different formats, as can be seen in this one where the "-", "2" and the ">>" are junk while scanned. My issue is to get the numbers into separate cell and then...

Please Refer to the post... http://chandoo.org/forums/topic/how-to-convert-a-string-which-has-both-numbers-and-text-to-a-time Any Help will be appreciated.

Another issue related to time and date. In Column A the below data is present, to get the title and time seperated is ok, but getting the time formatted as we did before is a bit of an issue. 19.40 "Axe". - 2 >> 21.00 "fish" >> 22.35 "peacock Feather >> 0.20...

In the same sheet, i am also trying to get the correct date. Issues faced are, one that i have to enter a date manually when ever new data is available in the first cell (column C) and the next cell calculates the date according to the condition set in the column B. Secondly i am using a...

You Guys Rock the trick did it the first time

we get scanned documents and the files does not contain standard formatting for the fields, although text only or number only fields have no issue but lately got stuck on this one think. After converting the time field which is in the format "12.30am" & "1.30pm" we get something like "1200am" &...