is it still open?
+
*I did not do this for you. God is here working through me for you.*
On Thu, Dec 4, 2014 at 9:53 PM, Atul Kavade wrote:
> Please find attached sheet
> and help
> Last sheet is for user database
> I need to give rights as per username
> eg.
> if username is Manisha then s
Kindly find the solution
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Saturday, December 6, 2014 9:14:25 AM UTC+5:30, Ashish_Bhalara wrote:
>
> Dear experts,
>
> I need function to receive data o
Can I get that file with the result
On Saturday, December 6, 2014 12:06:42 AM UTC+5:30, Paul Schreiner wrote:
>
> I have a worksheet template in which I display a 3-digit Product Code.
> I have a hidden worksheet that has a list of Product Codes and
> corresponding product names like:
> Code Prod
Dear experts,
I need function to receive data on fulfill particular cell data, the demo
is attached herewith, thanks in advance.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
--
Are you =EXP(E:RT) or =
I have a worksheet template in which I display a 3-digit Product Code.
I have a hidden worksheet that has a list of Product Codes and
corresponding product names like:
Code Product
000 Product_A
001 Product_B
002 Product_C
003 Product_D
I'd like to have a pull-down in the Product Code Field that
Welcome Putta.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
In index formula we are using index(array,1,0). Means whole 1st row is
selected, in this case 1st row has 1,2,3. So there is no increment but
formula is passing values all first row value to array..
+
*I did not do this for you. God is here working through me for you.*
On Fri, Dec 5, 2014 a
Hey vabz ,
Even a selected range can also be considered as an array. Can a range
variable work ???
Join(Application.Index(c01.Value,1,0), "|")
Next step
Join(Application.Index({1,2,3},1,0), "|") how it is selecting 2 even there
is no increment is going on
Join can combine the array values
Dear Friends,
I am new to excel and my query is very small.
I have to calculate yield to maturity for a bond. I am calculating it using
XIRR and yield function in excel. Values are different. XIRR =12.13%
whereas Yield =12.40%
Please advice me what I have done wrong in calculating yield. I have
Thank you Ashish..this is working fine
On Dec 5, 2014 1:52 PM, "Ashish Kumar" wrote:
> Hi Putta,
>
> Steps for Lock cells :
>
> Step 1: Select all cells in current worksheet with pressing the Ctrl key
> and A key together.
>
> Step 2: Right click, and select the Format Cell item from the context
Hi
when you perform index function on one row by x columns, result given by
excel is in Array..
e.g. put A in cell A1, B in Cell B1 & C in cell C1. Now write this formula
in A2, =INDEX(A1:C1,1,0)
now goto cell A2 & then press shift + f3, press enter.. see in result you
will see {"A","B","C"}, wh
Hi Putta,
Steps for Lock cells :
Step 1: Select all cells in current worksheet with pressing the Ctrl key
and A key together.
Step 2: Right click, and select the Format Cell item from the context menu.
Step 3: In the Format Cells dialog box, uncheck the Locked option
under Protection tab, and c
12 matches
Mail list logo