Kindly attach sample file.
On Wed, Sep 1, 2010 at 12:12 AM, Kurt wrote:
> Can't seem to get this working.
>
> If A1 is a calculated error (e.g., #NULL) OR If A1 = "--- ", make
> B1 = "NA"
>
> Otherwise: If A1 < Y1, make B1 = "!", otherwise make B1 = "" (i.e.,
> blank).
>
> This is what I hav
HLC
Dear Excel Friends,
I am a beginner in Excel.
I would like to know what is Excel Macro !
Can we develop a programme in Excel Macro ?
How to develop a small programme in Excel Macro?
What are the advantages ?
Is there any body in our community to help me with a simple example on
Excel *Ma
Can't seem to get this working.
If A1 is a calculated error (e.g., #NULL) OR If A1 = "--- ", make
B1 = "NA"
Otherwise: If A1 < Y1, make B1 = "!", otherwise make B1 = "" (i.e.,
blank).
This is what I have in B1, but it always returns a #NULL error.
=IF(OR(ISERROR(A1),A1="---"),"NA",IF(A1
Hello,
I have a spreadsheet as shown below:
Name ID Start Date Company
John A 1011/1/2010 A
Vicky T 1151/8/2009 A
Tim H 1126/1/2009B
Mike B 1137/1/2010 C
What I want to do is automatically create a pdf file for each company
with company name as
Hi,
I am trying to build an excel based system in which a person enter his
entry and exit time then system calculate his office duration and if
the time is greater then 8 hrs then it show full day or if it is
between 4 - 8 then it show half day or if it is less then 4 then
absent.
On the other sh
Hi,
I would like to ask you how to import excel file into Microsoft SQL
server via Microsoft SQL server management studio. I have an excel
file with one sheet containing data and I need to import it into SQL
server.
Could you please help me?
Thank you
Ivana
--
Hi,
I Love excel because it makes the finance manager in me to be more and more
creative in financial analysis and impress my bosses. SAP/Excel helped my
career in a big way :-)
best regards
rajesh
On Tue, Aug 31, 2010 at 5:04 PM, sudhir kumar wrote:
> hi ,
> I love excel due to its mathematic
Hi
This posting relate to a earlier one regarding birthdays on a excel
sheet.
in column a i got the /mm/dd
column b i got the person name and last name
column c i got the age of the person
in d1 i need every one that has birthday today with theiry respective
age next to the name. since the
hi ,
I love excel due to its mathematical interface, using excel is like u r
solving a puzzle with some logic .
On Tue, Aug 31, 2010 at 2:01 AM, obahor o wrote:
> I love excel becuz it helps me excel in my day-to-day data
> manipulation and analytics solution.
> Mog
>
> Sent from my HTC Snap on
Hi Expert,
thank you so much for your help, it solve my 90% of problem,
but actually i have aprox 60 charts in my dashboard. so for this is there
any comman macro, otherwise i have to write 60 macro, to assing each macro
to every chart.
Pls help
Regards
Pankaj k Pandey
On Tue, Aug
On 31 Aug., 03:27, Meimei wrote:
> I am writing a simple vba program. I used a few comboboxes in the
> program. But I found that as I click on the combobox, the font size in
> the drop-down list gets smaller each time, and after a few clicks, the
> font is too small to even see. Does anyone know w
Hello siti,
thanks for your solution. but i did not get it how it has happened. please
can you brief it.and tell me any solution which may forever in excel.
with regard,
Ankit
--
--
Some important links for excel us
On Tue, Aug 31, 2010 at 11:41 AM, C.G.Kumar wrote:
> Dear All,
>
>
> Debit note format in excel is required. If any one has kindly forward.
>
> Thanks & Regards,
>
> C.G.Kumar
>
> --
>
> --
> Some important links for e
HI
i'm ind the process of make a function that insert a new line under
the actvie copies the formalu from the above line. after this it
should create a new line in another sheet an the same location, which
is indicated be the selected active cell.
This new line in the other sheet should have a lin
Dear Pankaj,
Please find attachement.
Thanks,
Noorain
On Tue, Aug 31, 2010 at 11:05 AM, Pankaj Kumar wrote:
>
>
> --
> *Warm Regards
> Pankaj kumar
> M: 9899816107
> e-mail: rajputpanka...@gmail.com
>rajputpank...@yahoo.in*
> * rajputpankaj1...@rediffmail.com*
>
> --
>
>
Dear Pankaj,
Please see solved attachement.
Thanks,
Noorain Ansari
Mob:-9911176564
On Tue, Aug 31, 2010 at 10:44 AM, Pankaj Kumar wrote:
> Hi, All,
>
>
> i have a problem in excelsheet attached below
>
> --
> *Warm Regards
> Pankaj kumar
> M: 9899816107
> e-mail: rajputpanka...@gmail.com
>
Hi Bruno,
Thanks a ton for helping me.
Thanks
Kalyan
On Tue, Aug 31, 2010 at 3:41 AM, Bruno Bruno wrote:
> Hi Maries,
>
> This formula might look complicated, but it's actually simple if we "break"
> it into pieces.
> But before doing it, we first need to understand the idea: we want to,
> ba
17 matches
Mail list logo