Hello all,
I am attempting to write code for a Macro that will solve for
simultaneous equations. I Have 4 equations and 4 unknowns. I really
want (need) to do this using the Matrix operations (MInverse and
MMult) and therefore arrays.
I created a user form so the user may input the coefficients
Hellow Friends,
Please guide me all this query particular to Excel 2007 Version.
Thanks
On Sat, Oct 17, 2009 at 4:22 PM, big smile wrote:
> Hellow all excel guru's & friends.
>
> I have some query -- or i want to know the shortcuts.
>
> 1] Can we delete the name given to particular ce
Hi Ayush
Thank you so much & keep up the great support.
On 10/18/09, Ayush Jain wrote:
>
> Hi Mahesh,
>
> The OR,AND formula can be used as :
> OR(Logical test 1, Logical Test 2, ..)
> AND(Test 1, Test 2,.)
>
> =IF(OR(B26= "Add R",B26 = "CC"),"Req",IF(B26 =
> "Entered","WIP",IF(C26="B
cracking password of other programmers without his knowledge is a bad habit
much less a moral crime and a disrespect to the author. I hope this forum do
not tolerate this practice. let us help each other in the right way as we
always do. thanks for understanding.
On Mon, Oct 19, 2009 at 1:37 AM,
On the menu select Insert - Name - Define. You can add, change or
delete range names from there.
On Oct 17, 6:52 am, big smile wrote:
> Hellow all excel guru's & friends.
>
> I have some query -- or i want to know the shortcuts.
>
> 1] Can we delete the name given to particular cell in name bo
You may have a format issue. Try using Paste Special instead of just
Paste. Select All or Values with number formats to paste.
On Oct 17, 6:18 am, karthikeyan
wrote:
> Hi All,
> I put a validation in one excel worksheet
> It's dosen't accept the data's copy from one sheet to past this sheet.
> e
Hi...I'm trying to fill in a cell with the formula:
=IF(COUNT(RPM),LOOKUP(MIN(RPM),RPM,Worksheet!A:A),LOOKUP(IF(COUNTA
(RPM),RPM,Worksheet!A:A),"",""))
My Dept range = A:A
My RPM range = a column on another sheet
I was able to get this working before with a single variable declared,
then when I
First of all, it is not "easy" to disable this
SECURITY FEATURE. The whole idea is to make is
so that those EVIL people out there that get their
kicks out of writing virus' and finding some method
to get them spread as far as possible have made
it difficult for the rest of us.
Microsoft is allowi
Michael, You are always welcome...!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/13/09, Drayton, Michael E wrote:
>
> Thanks Sir!
>
> YOU ARE THE KING!!!
>
> Thanks ---
>
> regard
Hi Umesh,
I have used "OFFSET" function to get the name to which the target names are
matching. It picks the name which has got matched and takes that as a row
to get down in the list of the names, starting from first name in the list.
Let me know if you need any other help.
Best Regards,
--
DI
Hi Manish,
Enter the following code in workbook. (Press Alt + F11 -> double click on
this workbook -> Choose "workbook" from first filter drop down and "Open"
from second filter drop down.
Private Sub Workbook_Open()
MsgBox "Dont use command like 'Ctrl+X' OR edit in 'green field only"
End Sub
Be
Hi Saiprasath,
Copy the data which you want to change automatically in second sheet and
choose paste special - Paste Link.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/7/09, sai prasath
Hi Ahmed,
I have given a try to this. According to me, "today + 30 days" should be
"today - 30 days" because if the date coming from another sheet is less than
today, then it means it will be less than "today + X days". Use the
conditional formatting logics given in the attached workbook for bet
Hi Kamal,
I am having a software installed in my PC, which can crack the excel
password.
I got it installed from my vendor at the time of assembling of my system.
If you feel OK, then send me the zipped workbook and I can try un-locking it
for you.
Let me know if you need any other help. Thanks
Hi Saravana,
If the project is password protected, it will ask for the password when you
either -> Try to expand the project by clicking on the + sign on left of
it OR double click on the VBA project name. Any user who knows the password
would be able to open it and there are many softwares avail
Hi Praveen,
Your are using right function i.e, UPPER, but before that you should have
the data ready, which you want to convert in UPPER Case. So first use TEXT
function to take out the text from the date and then use UPPER function.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BC
Zaheer.., You are always welcome...!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/13/09, ~ Z A H E E R ~ wrote:
>
> *Thanx alot Dilip.*
>
>
>
> On Tue, Oct 13, 2009 at 7:44 AM, Dilip P
Hi Manoj,
Copy the desired data and select the range to paste. Press alt + ;
(semi-colon) on your keyboard and paste the data.
Note:- Alt + ; will select only visible cells.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yah
If I understand your issue correctly, you have data being imported
into an Excel spreadsheet in a repeatable format. If the data has
been placed in the spreadsheet in consistent locations, you can simply
use the CONCATENATE function in Excel to merge the cell contents.
Then, copy/paste (or drag)
It worksThanks for the info..
Best regards,
Ayush Jain
On Oct 16, 9:47 pm, Hemant wrote:
> Thank you so much Michael :)
>
> I am going to test it now!
>
> On Oct 15, 2:55 pm, Michael wrote:
>
> > Why does no one seem to use the [A1] notation in preferece to Range
> > ("A1")?
>
> > [A1].Sel
Hi Karthikeyan,
Greetings!
Please follow the below steps to avoid the Enable/Disable macros :
1. Look in C:\Program Files\Microsoft Office\Office (or C:\Program
Files\Microsoft Office\Office10), and there should be a program called
selfcert.exe.
2. Run the selfcert.exe program (just double
Hi Mahesh,
The OR,AND formula can be used as :
OR(Logical test 1, Logical Test 2, ..)
AND(Test 1, Test 2,.)
=IF(OR(B26= "Add R",B26 = "CC"),"Req",IF(B26 =
"Entered","WIP",IF(C26="Bounce","Bounce",IF(OR(B26="Cancel",B26="NTU",B26="Decline"),"Refund","PP"
You can use above formula for
Dear All
In attach sheet i want to use if condition based on two cell value, how to
write IF formula
using OR, AND. i will greatly appreciate any help on this.
Thank You
--~--~-~--~~~---~--~~
-
Hi All,
I have create a macro and sent to others these people open that
particular file excel says popups
'ENABLE / DISABLE macros' they clicked DISABLE macros so macros are
not working.
How can i avoid this Proplem? Anybody knows let me know.
thanks
karthik
--~--~-~--~~
24 matches
Mail list logo
