Hi Krishna,
see file attached, in that second sheet u see in b column i used Left
function and in c column Vlookup
left function i used =left(A2.13)
and vlookup answer is #N/A
Because In System Data sheet Left function answer is not there
if i decrease the no's in left function i ll get the an
Dear Krishna,
I mean we can copy the range of cells A1:B5 from excel to note pad. But , it
is very difficult to copy the whole workbook to notepad.
Regards,
Vijaykumar
On Mon, Oct 18, 2010 at 12:47 AM, Krishna wrote:
> How can we copy the contents from excel to notepad. For instance the
> ra
Hi Excel Gurus,
Is it possible to create a Excel macro using which, it has take data's from
a excel file and it need to update in a specified web page. I have given the
example below
In Excel file
Sl.No
Name
Emp.No.
Enterprise id
Supervisor Name
Supervisor Email id
1
Selva
106
Hi Excel Gurus,
Is it possible to create a Excel macro using which, it has take data’s
from a excel file and it need to update in a specified web page. I
have given the example below
In Excel file
Sl.No NameEmp.No. Enterprise id Supervisor Name Supervisor Email id
1 Selva 1061125
Dear Girish,
Sorry I didn't understand what you are looking for,
Please give an Example, what you want exactly?
May be i have some communication problem to understand your query.
Thanks,
Excelkid
On Mon, Oct 18, 2010 at 7:52 PM, girish kumar
wrote:
> Dear Experts,
>
> need one urgent help fro
Can anyone help with this?
Not sure how well this copied but I have gl accts on the left with
the
months across the top. I need to copy only the acct data over to
another tab and occasionally new accounts will be inserted so I don't
want to "lock" in the range. I would like to go to Dec Actual
Dear Experts,
need one urgent help from you guys i have attached one file having 2 sheets
named "system data" & "Raw CDR"
i need a formula for getting name in sheet Raw CDR
for exam
sheet system data having no
93 Afghanistan Other
and Raw Cdr having No
93854512115
for getting destination na
Hi, I have the following code that calculates the number of days
(excluding Sundays) between two dates, and ideally I'd like to add
another parameter to my function to allow me to exclude non-working
days (in a similar way to the in-built NETWORKDAYS function - -
NETWORKDAYS(start_date,end_date,ho
Hi Priya,
Please find attachement with solution.
Thanks,
Noorain Ansari
On Mon, Oct 18, 2010 at 1:38 AM, Priya Jose wrote:
> Dear All,
>
> Thanks for your prompt reply, as i mentioned in my query what is that i am
> looking for is a formula but not Pivot table which i now very well this can
>
Excellent explanation.
and to me too, 3:48 is NOT equivalent to 3.48 hours.
Well Done Paul
On Fri, Oct 15, 2010 at 5:42 PM, Paul Schreiner wrote:
> just so you know:
>
> 3 hours 48 minutes is NOT 3.48 hours.
>
> it's 3.8 hours...
>
> If you're wanting the hours/minutes expressed as a deci
I could not identify whether it is a solution or your query.If this is
solution pls ignore my mail, otherwise you may please explain the objective
and problem.
Thanks & Regards,
C.G.Kumar
On Sat, Oct 9, 2010 at 2:20 PM, SUMIT VYAS wrote:
> Thanks For all member of Excel-macros group.
>
> an
Dear All,
Thanks for your prompt reply, as i mentioned in my query what is that i am
looking for is a formula but not Pivot table which i now very well this can
be acheived. If you guys look at the data it has something like pulling the
data with respect to a value from left and right.
thats the
you can save your workbook (containing ONE worksheet)
as XX.TEXT
or as XX.CSV
please note the notepad (a TEXT editor) is not contains multi cells like
excel worksheet
On Mon, Oct 18, 2010 at 2:07 PM, Krishna wrote:
> Dear Vijaykumar,
>
> Do you mean, an " is inserted for all the da
Dear Vijaykumar,
Do you mean, an " is inserted for all the data? Can you please
illustrate by an example?
Thanks,
Krishna
On Oct 18, 2:04 am, "P.VIJAYKUMAR" wrote:
> Dear krishna,
>
> It is possible to copy the contents of Excel to note pad.But, the only
> problem is the pasted content will not
Dear krishna,
It is possible to copy the contents of Excel to note pad.But, the only
problem is the pasted content will not maintain the same format as in Excel.
Regards,
Vijaykumar
On Mon, Oct 18, 2010 at 12:47 AM, Krishna wrote:
> How can we copy the contents from excel to notepad. For inst
Hi Priya,
Please find attachment.
Let me know if you need anything else.
Thanks & Regrds,
Kaushik Savla
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitte
16 matches
Mail list logo
