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...
@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...
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...
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
Hi, I am still learning excel..so I am sure there will be much better answers following this. But give this a try..
Assuming you have the data from B2:B10
In cell c2 type this formula
=OR((IF(B3=B2,TRUE,FALSE)),(IF(B2=B1,TRUE,FALSE)))
copy this formula from c2:c10
In conditional...
Hi, I have an excel template i circulate for users, who enter some data and save filename in a particular format ''their_name+ddmmyyyy.xlsx'' and send me back. Its very difficult to explain everyone to use a same format so that it is easy for me to store, sort the files in a folder. i was...