Recent content by smanjunath

Hi, We have a shared network folder and many users have created nesting folders in them as per their requirement. When we try to put a hyperlink in a excel file, it does not work for few deeply nested folders since the total character length in the hyperlink crosses 256. Is there a way out...

Hi Faseeh, Thanks for the reply. Not exactly what i was looking for, but does gives an inspiration... Please let me know if you come across something on the line drawing front. (Fill color is an added advantage) something like this...

Dear Chandoo-ites, My Mother-in-law is very creative and loves Designing Rangolis..(floral designs made with different colours and line drawings in rural Indian Households) She was very pleased when I gave her printed sheets of blank rangoli templates (a matrix of dots evenly spaced and...

Thanks, it works, I can use the result value (if >3) for conditional formatting... But has a minor problem, If the value in A1 is a whole number (no decimals) as you have pointed out, it returns #N/A, i could use 'iferror' to get rid of it, though. meanwhile i was using this formula...

Hi, In one of the load templates we require the user to enter quantity in lbs in one of the column, and the user need to enter the value only upto 3 decimal points. We could have sent the template with input restrictions through data validations, but apparently we did not. Now how do i check...

@ Montrey sorry i could not get what u mean..

@Hui, I did use secondary axis to start with, which works fine, but my 'end user' wants all axis labels one one side (left side) only. 100 80 60 40 20 0 100 80 60 40 20 0 and not like 100 80 60 40 20 0 ............100 ............ 80 ............ 60 ............ 40 .............20...

oops you changed it before i could post...

oldchippy... dont you mean =HYPERLINK(MID(A1,2,LEN(A1)-3))

you mean you want to remove the double inverted quotes and the dot after org try this.. =MID(A1,2,LEN(A1)-3)

Hi, extremely sorry for late reply. The scale is pretty much fixed. 0-100 it is a clustered vertical bar graph the idea is to have two different graphs in one chart....so i made one with positive values and other with negative values so that they appear in the same chart. the problem was...

Hi, I am in need of a number format code which will show the vertical axis labels as below 100 80 40 20 0 100 (actually -20) 80 (actually -40) 40 (actually -80) 20 (actually -100) 0 (actually -120) I hope i made some sense...

This was also Exactly what i needed, worked great for me.. Thanks

Can we show a window in excel where it can reflect that the processor is trying to calculate/ update the sheet with Macros. It does come in bottm right corner, but for ease of use can we show percentage processed in the sheet

why don't you simply use pivot table? If u need help in Pivot table creation, pl let us know.