Also Sumproduct is useful for numaric value.
Is there any other formula, that will work as SUMPRODUCT for text??
Pls suggest.
On Feb 5, 11:05 am, Manish wrote:
> Is it possible to hide the complete row based on lookup value??
> For example in your solution, if i lookup value x than i want to hid
Is it possible to hide the complete row based on lookup value??
For example in your solution, if i lookup value x than i want to hide
row 14 because the lookup result is 0 /Blank. And if i change the
value and look the value y i want to hide both row 13 and 14.
Simply, I want automtion for hide bl
Can someone define formula because I dont know macros.
Regards,
Solomon
-- Forwarded message --
From: solomon raju
Date: Thu, Feb 3, 2011 at 3:14 PM
Subject: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT
To: excel-macros@googlegroups.com
Hi All,
Please find the attached
On Feb 3, 10:18 pm, flebber wrote:
> I have a table of data containing name and time information. Excel and
> Access can understand it whilst it is in a format such as 12.2 or 11.8
> but when it is in a minutes format it cannot.
>
> For example I have a macro which I am still working on which wi
hello Sir,
Sorry for delay replay please find the dummy my database sheet with the same
column no which is apper in database
i want the same macro or formula as a output for attached file.
Once again Congrates Ashish sir.
On Thu, Feb 3, 2011 at 2:16 PM, ashish koul wrote:
>
> yo have sent me
It's actually very easy!
It's called a Selection_Change event.
on the worksheet, right-click on the sheet "tab" name and select View Code.
in the VB Edit window, select the pull-down on the upper left and select
Worksheet
The default event is the Worksheet_SelectionChange event!
the event gets
Hi,
I'm not sure if this is possible, so I thought I would cast a wide
net.
Description: I have an Excel spreadsheet with many sheets of summary
and detail information of employees.
On a summary sheet, I have rows that list job titles and the quantity
of employees with that job title in the adjacen
Put into VBA moduke the "words" function below in your and use this
formula:
=UPPER("RUPEES "&words(B31) &" ONLY")
Function words(fig, Optional point = "Point") As String
Dim Digit(14) As Integer
alpha = Array("", "One", "Two", "Three", "Four", "Five", "Six",
"Seven", "Eight", "Nine", "Ten", "Ele
Have u configured your Outlook..
Rajan.
On Thu, Feb 3, 2011 at 11:26 PM, Jagadeesh B S wrote:
> Ashish Koul
>
> Its not working...:(
>
> Regards
> Jagadeesh B S
>
>
>
> On Fri, Feb 4, 2011 at 12:15 PM, ashish koul wrote:
>
>> HI
>>
>> try this see if it helps
>>
>> paste unique names and email
Ajay,
open the file
go to "review" tab on the menu ribbon
click on unprotect workbook
now you can add new sheet
Regards,
Jaibeer
On Fri, Feb 4, 2011 at 3:17 PM, MITTAL AJAY wrote:
> Hi , can anybody help me in inserting a new sheet in this file & what was
> the issue.
>
>
>
> *With Warm Regard
Please check if your workbook is not protected..
On Fri, Feb 4, 2011 at 1:47 AM, MITTAL AJAY wrote:
> Hi , can anybody help me in inserting a new sheet in this file & what
> was the issue.
>
>
>
> *With Warm Regards,*
>
> * *
>
> * Ajay Mittal*
>
> *This Message was sent from Indian Oil Messag
The workbook is protected.
Luckily, without a password.
Simply unprotect the workbook.
Paul
From: MITTAL AJAY
To: "excel-macros@googlegroups.com"
Sent: Fri, February 4, 2011 4:47:46 AM
Subject: $$Excel-Macros$$ FW: EXCEL FILE
Hi , can anybody help me i
Hi Group,
I have also learnt lots more in excel from Asish Koul. His blog is very
good to learn excel.
On Fri, Feb 4, 2011 at 1:37 AM, mahamadou lawali wrote:
> Congratulations Ashish!!
> His posts motivated me to learn more And I've learned a lot.
> Thanks
>
> On Feb 2, 9:55 am, Ayush wro
Ashish Koul
Its not working...:(
Regards
Jagadeesh B S
On Fri, Feb 4, 2011 at 12:15 PM, ashish koul wrote:
> HI
>
> try this see if it helps
>
> paste unique names and email ids on sheet 3
>
>
>
> On Thu, Feb 3, 2011 at 2:50 PM, Jagadeesh B S wrote:
>
>> Ashish Koul
>>
>>
>>
>> I am using M
Please use =LEN("Cell reference") it will count the words / letters of specific
cell
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Jorge Marques
Sent: Friday, February 04, 2011 1:17 AM
To:
use len function. like u want to calculate num of latter in 1 cell, than
=len(a1).
On Fri, Feb 4, 2011 at 1:17 AM, Jorge Marques wrote:
> Hi, is there anyway of counting words ou letters in a specific cell?thank
> you very much
>
>
> --
>
> --
Hi,
use Len function..
=LEN(cell_reference)
Regards,
Manoj Kumar
On Fri, Feb 4, 2011 at 1:17 AM, Jorge Marques wrote:
> Hi, is there anyway of counting words ou letters in a specific cell?thank
> you very much
>
>
> --
>
> ---
17 matches
Mail list logo