Dear All ,
Very Good Afternoon,
Please find the attachment where i have put value formula for date column
..but it is not working ..Same formula is working with other computer .
Please help for the same as i have same problem is since long .
Is there any setting i have to change in excel ..Plea
Hello Ashish,
still its showing total for visible cell also that is 6 in this case. Is
there any function relate to pivot table?
Thanks in advance.
Regards,
Chandru
On Fri, Nov 22, 2013 at 7:39 PM, ashish koul wrote:
> =SUBTOTAL(3,F:F)
>
>
> On Thu, Nov 21, 2013 at 12:49 PM, Chandra Shekar <
THANKS BRO REALY HEPLFULL ...
On Thursday, May 10, 2012 4:49:25 PM UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear Group,
>
> Please find attached Interview questions and answers for MS Excel+VBA+MS
> Access+SQL Server.
>
> If any one have this type of question and answers, Kindly share with group.
try this
=IF((ISERROR(VLOOKUP(B2,'C:\Users\admin\Downloads\[Master
Sheet.xlsx]Sheet1'!$B:$B,1,0))),"Not Available","Available")
and apply conditional formatting in col a
or
Sub sample()
Dim wkb As Workbook
Dim i As Long
Set wkb = Workbooks.Open("C:\Users\admin\Downloads\Master Sheet.xlsx")
For i
Hi Ashish,
I have attached the sample sheets.
assume Master sheet is saved in D folder. and Consolidated sheet is saved
in E folder
Thanks & Regards,
Prabhu R
On 24 November 2013 13:07, ashish koul wrote:
> share some sample workbooks
>
>
> On Sun, Nov 24, 2013 at 1:06 PM, Prabhu Pinky wrote:
