$$Excel-Macros$$ opening for ETL Tester

2022-02-08 Thread Kubra Ali
Hadoop eco system Kind Regards! [Logo Description automatically generated] Weblink: Click<http://www.v2innovationsinc.com/> Open Position : Dice<https://www.dice.com/company/90887725> Kubra Ali V2 Innovations Inc<http://www.v2innovationsinc.com/> 42180 Ford Rd, Ste 302, Canton,

$$Excel-Macros$$ We are looking for Remote - QA Tester - 1 Year Contract to Hire

2022-02-08 Thread Kubra Ali
ly to continuously improve on processes and skills Self-directed, capable of determining priorities among multiple QA tasks Kind Regards! [Logo Description automatically generated] Weblink: Click<http://www.v2innovationsinc.com/> Open Position : Dice<https://www.dice.com/company/90887725&

$$Excel-Macros$$ Opening for Frontend UI Developer

2022-01-27 Thread Kubra Ali
limited direction, a self starter. - Kind Regards! [Logo Description automatically generated] Weblink: Click<http://www.v2innovationsinc.com/> Open Position : Dice<https://www.dice.com/company/90887725> Kubra Ali V2 Innovations Inc<http://www.v2innovationsinc.com/> 42180 Ford R

$$Excel-Macros$$ Details & Documents

2022-01-27 Thread Kubra Ali
We can schedule interview within 12 working hours for the right consultant. 90% of our submission are requested to interview by our client. So don't wait, update the below details, and send it back to me. We need Work Authorization Copy, Driving License, i94 Copy [Checking your Arrival Date in

$$Excel-Macros$$ Long-Term Contract for a .Net Developer in Alpharetta, GA.

2022-01-20 Thread Kubra Ali
.dice.com/company/90887725> Kubra Ali V2 Innovations Inc<http://www.v2innovationsinc.com/> 42180 Ford Rd, Ste 302, Canton, MI 48187 Email: ku...@v2innovationsinc.com<mailto:ku...@v2innovationsinc.com> Cell: (734) 408 4730 Fax: (734) 408 4744 LinkedIn<https://www.linkedin

$$Excel-Macros$$ VBA website scrapping help

2020-08-09 Thread dii ali
Hi All, I found the below sample code which works fine. I tried to mimic the code by using another website, but cannot even reach the input parameters. The website has two text boxes. Once you insert value to the first box, it will automatically return a result value to the second box ( no butt

$$Excel-Macros$$ Urgent Need Spark BigData Developer - Thousand oaks, CA.

2018-12-03 Thread Affan Ali
Hello professional, Below is an immediate requirement with one of my clients. *Title: Bigdata -Spark Developer * *Location: Thousand Oaks, CA* *Duration: Long Term* *Skills:* Bigdata - Spark At least 3 years of hands on experience in Spark (fundamentals, RDD and data frame APIs) Good ex

$$Excel-Macros$$ We are here to help you

2018-11-30 Thread Ali Zaidi
tablishing a long term good working relationship with you & your esteemed organizations. If you need any further information above mention products please write us and also share with us your tender information & B.O.Q Documents. Sayied Ali Shahid Manager Business Development 0312-

Re: $$Excel-Macros$$ MSBI / SSIS ETL Developer

2018-11-30 Thread Nasir Ali
Hi, Please find the attached resume for this position. Thanks & Regards Nasir Ali +968 71729076 On Wed, Nov 28, 2018 at 1:51 PM Nitya Recruiter wrote: > > > > * Position: MSBI / SSIS ETL Developer* > > *Location: Seattle, WA* > > *Duration: 3-6+ months with exten

$$Excel-Macros$$ Bio-metric Payroll System Karachi

2018-11-25 Thread Ali Zaidi
Implement Payroll Bio-metric Attendance system and save your labor cost & other Finance Modules with customized reporting as you need C Ali Shahid 0331-9922366 E zaidia...@gmail.com L 201 Alrehman Center at Sha

$$Excel-Macros$$ Oracle Technical Project Manager - Boston, MA

2018-11-13 Thread Affan Ali
Hi, Hope you are doing well. Below is an immediate requirement with our client. Please go through the job description and if it interests you, reply with an updated resume attached and the best time to talk to you. *Title : Oracle Technical PM* *Location : Bos

$$Excel-Macros$$ Need Oracle HCM Analyst - Long Beach, CA - 6+ Months contract

2018-11-06 Thread Affan Ali
*Need Oracle HCM Analyst* *Long Beach California* *6+ Months Contract* *Any Visa Workable - Please share genuine candidate profiles* *Job Description:* Assist in fully integrating the Oracle HCM cloud system into current business applications and provide input on best practices Configure Oracle H

$$Excel-Macros$$ Salesforce Developer - Chicago, IL - 11 months

2018-11-01 Thread Affan Ali
*Role: Salesforce DeveloperLocation: Chicago, ILDuration: 11 months* *Need locals only - InPerson Interview Mandatory* *Interview process:*For qualified candidates of interest there will be 3 interviews in total. 1st: Phone screen 2nd: Technical screening in person 3rd: Final round in person *

$$Excel-Macros$$ Business Analyst - Montvale, NJ

2018-10-31 Thread Affan Ali
*Title: Business Analyst* *Location: Montvale, NJ* *Duration: 3 months* *Job Description:* This is a 3 month Consulting assignment for a Business Analyst to help with Documentation and StoryBoarding in Smaply. They will work closely with the Marketing team as

$$Excel-Macros$$ Linux System Admin - San Francisco, CA

2018-10-25 Thread Affan Ali
*Role: Linux System AdminLocation: San Francisco, CADuration: 6 months +* *Required:*Experience with Linux systems administration including solid scripting skills in Bash and Python Deep understanding of distributed systems concepts and principles (consistency and availability, liveness and safet

$$Excel-Macros$$ Backend Developer with node.js - Bellevue, WA

2018-10-25 Thread Affan Ali
*Job Title/Role: Node.js DeveloperJob Location: Bellevue, WAProject Duration: 12+ Months* *Detailed Job Description: * Extensive experience in building REST web APIs with NodeJS and ExpressJS on Heroku or similar cloud platform Should have experience in integrating RESTful APIs with other enterpri

$$Excel-Macros$$ Sharepoint Administrator with JIRA

2018-10-11 Thread Affan Ali
*Role: Sharepoint Administrator with JIRALocation: Jefferson City, MODuration: 6+ Months* *Fast moving requirement – Interview ASAPPreferred **GC, US Citizen,* *H1B is workable.* *Job Description: * Provide administration and development support of both the existing and new JIRA and SharePoint

$$Excel-Macros$$ Urgent Client Need - People Soft Finance Consultant (Techno Functional) - Herndon, VA

2018-09-28 Thread Affan Ali
*Hello professionals,Alan Smith here from Pull Skill technologies, recruiting for a People Soft Finance Techno Functional Consultant for a fast moving requirement. send your hot list to a...@pullskill.com reach me on * *Title : PS Finance Consultant (Techno Functional)Loca

$$Excel-Macros$$ Urgent Client Need - Hadoop Big Data - Overland park, KS - Interview ASAP

2018-09-28 Thread Affan Ali
*Role: Hadoop Administrator* *Location: Overland park, KS * *Duration: 6 months+* *Urgent Need - Interview ASAP* *Job Description:*Responsible for implementation and support of the Enterprise Hadoop environment. Involves designing, capacity arrangement, cluster set up, performance fine-tuning

$$Excel-Macros$$ Fast Moving Requirement - Urgent Need - Azure Architect - Ewing, NJ - 6 Months

2018-09-26 Thread Affan Ali
*Title: Azure Architect* *Location: Ewing, NJ* *Duration: 6 months* *Fast moving Requirement – Interview ASAP* *Azure Architect with: * 8-10 plus years of IT experience on Cloud big data, Big Data lake implementations , ETL, BI, OLAP, Analytics, Real time integration, Large Volume Anal

$$Excel-Macros$$ Fast moving Requirement - Urgent Need - ORMB Technical Solutions Architect – Interview ASAP

2018-09-26 Thread Affan Ali
*Title : ORMB Technical* *Location : Norcross, GA* *Duration : 6 Months* *Need ORMB Technical Solutions Architect – Interview ASAP* *Required:* Should be hands on technical solution architect having 15+ years Oracle ERP experience having don

$$Excel-Macros$$ Urgent need -.Net Lead with Java Script & NodeJS | Baltimore, MD

2018-09-20 Thread Affan Ali
*Title : .Net Lead with Java Script & NodeJS* *Location : Baltimore, MD* *Duration: 6 Months* *Job Description:* Agile Exp. Client facing Role Lead having strong working experience in .NET and Java Script, NodeJS To Develop technical interfaces, specifications and architecture To develo

$$Excel-Macros$$ SAP SD Functional Consultant | Houston, TX | 6 Months +

2018-09-19 Thread Affan Ali
*Local (Houston Based candidates) gets more preference.* *Title: SAP SD Functional Consultant* *Location: Houston, TX* *Duration: 6 Months + * *Year of Exp – 5-8 Years* *Position / Role* • Apply conceptual knowledge of business processes and technology to solve complex business process an

$$Excel-Macros$$ Hadoop Administrator | Overland park, KS | 6 months+ | Interview ASAP

2018-09-18 Thread Affan Ali
*Role: Hadoop Administrator* *Location: Overland park, KS* *Duration: 6 months+* *Interview ASAP – 6 years of experience required* *Job Description:* Responsible for implementation and support of the Enterprise Hadoop environment. Involves designing, capacity arrangement, cluster set up, p

$$Excel-Macros$$ Business Analyst Healthcare Domain | Austin TX | 6+ months

2018-09-18 Thread Affan Ali
*Title: *Business Analyst Healthcare Domain *Location: *Austin TX *Duration: *6+ months- all my people get extended continuously on this multi-year project. *Interview ASAP - Immediate Joining - 6 positionsKey skills:* Strong to extensive Medicaid experience Claims engine experience PLEXIS Quant

$$Excel-Macros$$ Urgent Required - QNXT Analyst - Long Beach, CA - long term - interview ASAP.

2018-09-17 Thread Affan Ali
*Role: QNXT Analyst* *Location: Long Beach, CA* *Duration: 6-12 months* *Urgent Requirement – Interview ASAP* *General Information* *Job Description Summary:* Responsible for the daily configuration maintenance within the Configuration Information Management (CIM) Operations Team. Under g

$$Excel-Macros$$ SQL Developer - In-person is must

2018-09-13 Thread Affan Ali
*Role: SQL Developer* *Location: Dearborn, MI* *Duration: 4 months **Interview: In-person* *Job Description:* *Essential Job Functions:* • Leading the development and implementation of advanced recurring automated report and dashboard solutions in support of business objectives. • Deve

$$Excel-Macros$$ Multiple job requirements @ GNRSystems

2018-08-29 Thread ALI HAMED
ards,* *­­­* _ *HABEEB ALI HAMED| IT RECRUITER.* <https://www.linkedin.com/in/habeeb-ali-b73697163/> 703 357.1978 (*Ext* - 102) *| Fax *571.429.3614 *|* *Email:* *haha...@gnrsystems.com * *GNRSystems, Inc.* *|* Development –

$$Excel-Macros$$ 16th digit show zero in excel

2018-06-29 Thread Ali Abbas
> > Dear All, when I entered 16th digit in excel excel automatically shows it > zero. I need enter 16 or 17 digit in single cell. Plz guide how to fix this > issue. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of t

$$Excel-Macros$$ Mini MBA in Strategic Planning ماجستير التخطيط الاستراتيجي المهني المصغر والممنوح من جامعة ميزوري – الولايات المتحدة الأمريكية مكان الانعقاد : المملكة المغربية - كازابلانكا موعد الانع

2017-02-21 Thread sara ali
* الدار العربية للتنمية الادارية * *تقدم* *Mini MBA in Strategic Planning* *ماجستير التخطيط الاستراتيجي المهني المصغر* *والممنوح من جامعة ميزوري – الولايات المتحدة الأمريكية* *مكان الانعقاد : المملكة المغربية - كازابلانكا* *موعد الانعقاد : من 15* * الى 26 يوليو 2017 م* *بهدف : * *

$$Excel-Macros$$ الدورة التدريبية تكنولوجيا الإدارة الذكية التحول من الإدارة الإلكترونية الى الإدارة الذكية إدارة المستقبل والخدمات الذكية دبى – الامارات العربية المتحدة )Smart technology management)

2017-02-20 Thread sara ali
*الدار العربية للتنمية الإدارية* *بالتعاون مع الإتحاد الدولى لمؤسسات التنمية البشرية* *الدورة التدريبية * *تكنولوجيا الإدارة الذكية * *التحول من الإدارة الإلكترونية الى الإدارة الذكية * *إدارة المستقبل والخدمات الذكية * *دبى – الامارات العربية المتحدة * *)**Smart technology management)* *خل

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

2016-12-10 Thread Mohammad Ali Mehebub Hassan
Please add my Number 9932274103 On Sat, Dec 10, 2016 at 3:05 PM, LEARNING EXCEL wrote: > Please add my Number 9600160150 > > On 10 December 2016 at 13:01, sugat misra wrote: > >> Please adde me as well 8880740879 >> >> On Saturday, 10 December 2016 03:55:25 UTC+5:30, julienne...@yahoo.com >> wr

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

2016-08-31 Thread Mohammad Ali Mehebub Hassan
e for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post

$$Excel-Macros$$ Break axis help in scatter chart plz

2015-09-21 Thread Ali Abbas
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

$$Excel-Macros$$ Plot cut in Y axix in scater chart

2015-09-21 Thread Ali Abbas
Dear All, hope u are all is well...please help me about caption. How to Plot cut in Y axix in scater chart -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

$$Excel-Macros$$ Show range in scatter chart x axis

2015-09-17 Thread Ali Abbas
Dearn All, How to put range (1-99, 100-199, 200-299 so on) in scattar chart x axis -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) U

$$Excel-Macros$$ Excel Calculator

2015-07-30 Thread Ali Abbas
My Dear How to make calculater with excel..with Vb or with out Vb. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

$$Excel-Macros$$ XL formulas not auto updated

2015-06-18 Thread Ali Abbas
Dear All Hope you're all well...my problem is my one excel work book's formulas not updated automatically. Again and again I do press F2+Enter on any single cell. I have already used check formula+ calculation option + automatic option but no any advantage of its on and off. -- Are you =EXP(E:RT)

Re: $$Excel-Macros$$ Formula for auto generated code

2015-05-31 Thread Ali Abbas
Dear All, Hope all of you are well. I need for a formula which can generate codes series automatically. Like I have a code series 1040004500 when I have press TAB then the series code like that 1040004600..mean 45 convert into 46. On May 31, 2015 9:45 PM, "Ali Abbas" wrote:

Re: $$Excel-Macros$$ Re: Formula for auto generated code

2015-05-31 Thread Ali Abbas
My how do Add 100 in query. Plz do attach sample file On May 31, 2015 10:15 PM, "Mandeep Baluja" wrote: > Hey Ali, > > In answer to your query you can simply do this by adding 100 in the Value, > But it doesn't seems to me your query is that much simpler . Please c

$$Excel-Macros$$ Formula for auto generated code

2015-05-31 Thread Ali Abbas
Dear All, Hope all of you are well. I need for a formula which can generate codes series automatically. Like I have a code series 1040004500 when I have press TAB then the series code like that 1040004600..mean 45 convert into 46. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d

Re: $$Excel-Macros$$ Conditional Formating Problem

2015-05-15 Thread Ali Abbas
Thank very much Ganesh Problem Solve On May 14, 2015 4:14 PM, "Ganesh N" wrote: > HI abbas, > > Use the conditional formatting with "Use a formula to determine which > cells to format' > > Regards, > Ganesh N > > On Thu, May 14, 2015 at 3:24 PM, Ali

$$Excel-Macros$$ Conditional Formating Problem

2015-05-14 Thread Ali Abbas
Dear All. Hope u r all well. I have two column with numbers. My requirement is if one column values is greater than other then greater values color should be red and its smaller values color is green. How can I compare two columns by using of conditional. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)

$$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

2015-03-30 Thread Saddam Ali
sorry i forgot to attach, this is the attachement On Monday, March 30, 2015 at 3:49:00 PM UTC+3, Saddam Ali wrote: > > Kindly find the attached excel work book and possibly assist. i need to > match all the data of the first sheet to the outstanding in the second sheet > > On M

$$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

2015-03-30 Thread Saddam Ali
Kindly find the attached excel work book and possibly assist. i need to match all the data of the first sheet to the outstanding in the second sheet On Monday, March 30, 2015 at 12:37:28 PM UTC+3, Saddam Ali wrote: > > My name is Baricha, from Kenya. I work in a bank and so i cannot

$$Excel-Macros$$ How can I match two different data, where only a reference number and amount are common.

2015-03-30 Thread Saddam Ali
My name is Baricha, from Kenya. I work in a bank and so i cannot upload the data because Its sensitive and also a breach of contract. I normally receive data from two different sources, and i am required to match the two data, the only common features between the 2 data, are the amount and a

Re: $$Excel-Macros$$ Copy data from multiple sheets into single sheet.

2014-03-29 Thread Satiqjaffar ali
thanks a lot Ravinder On 27 March 2014 13:08, Ravinder wrote: > PFA > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Satiqjaffar ali > *Sent:* Wednesday, March 26, 2014 11:47 PM > *To:* excel-macros@googl

$$Excel-Macros$$ Please send me add ins for number to text in xl

2014-02-26 Thread Ali Abbas
-- Forwarded message -- From: "Dan Burfield" Date: Dec 4, 2013 3:06 PM Subject: $$Excel-Macros$$ need help with nested IF AND formula To: Cc: Hi, thx in advance for your help. I am trying to build a spreadsheet that will help calculate medication doses. The variables involved are

Re: $$Excel-Macros$$ Auto 2 rows insert after every row ?

2014-02-10 Thread Ali Abbas
t blank rows (From row 2001 to > 4000). > 4. Repeat paste from row 4001 to 6000. > 5. Sort on the number column. It will put is as 1,1,1 then 2,2,2 and so on. > 6. The first 1 will have your data and the other two will be blank rows. > 7. Delete the number column. > > HTH > >

$$Excel-Macros$$ Auto 2 rows insert after every row ?

2014-02-10 Thread Ali Abbas
Dear All I have data in balk near to 2000 rows now I need to insert 2 rows after every rows if I am done this manual this is big problem and time wasting plz guide how cam I. Done this by macro or with any other way. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's

$$Excel-Macros$$ Control filter with macro

2013-12-23 Thread Ali Abbas
Dear all, how can we control Filter with the help of macro bottons. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ sum numbers only

2013-12-16 Thread Satiqjaffar ali
Hello Priti, Thanks for effort, and can you please explain the same with SUMIFS function.? On 16 December 2013 21:01, priti verma wrote: > Hi Satiqjaffar ali, > > Please try this With Control + Shift + enter > =SUM(IFERROR(VALUE(IF(G16&F17=$E$6:$E$12&$F$6:$F$12,$G$6:$G$12,

$$Excel-Macros$$ sum numbers only

2013-12-16 Thread Satiqjaffar ali
Hello experts, Can you please assist me to sum numbers only in cell. Please find attachment and assist. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/dis

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
Thanks my dear thank you very much. On Nov 28, 2013 12:33 PM, "Ashish Kumar" wrote: > Hi Ali Abbas, > > Press ALT + F11 for Go to the VBA Application, then click on Tool, after > that click on VBA Project Properties, then click on protection and put your > passward

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
Thanks my dearcan we protect this hidden sheet with passward.? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread t

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
ou select the worksheet from VBA project and then > choose your dropdown option. > > > Regards, > Vasim Shaikh > > On Thursday, November 28, 2013 4:35:25 PM UTC+5:30, ali abbas wrote: >> >> my dear when I am use this option than a error comesunable to set >

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
sday, November 28, 2013 4:35:25 PM UTC+5:30, ali abbas wrote: >> >> my dear when I am use this option than a error comesunable to set >> visible properties of the worksheet class...now what I am doing plz help >> On Nov 28, 2013 10:57 AM, "Ali Abbas" wro

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
my dear when I am use this option than a error comesunable to set visible properties of the worksheet class...now what I am doing plz help On Nov 28, 2013 10:57 AM, "Ali Abbas" wrote: > Thaks > On Nov 28, 2013 10:39 AM, "Shaikh Vasim" wrote: > >> Okies

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
Thaks On Nov 28, 2013 10:39 AM, "Shaikh Vasim" wrote: > Okies, > > > Go to Developer - Visual Basic - Select the sheet (you want ro hide from > the VBA project box) > in VBA editor - View - Properties window > in Properties window box - Visible (last option) and change it from > dropdown to optio

Re: $$Excel-Macros$$ Re: Hide to excel sheet

2013-11-28 Thread Ali Abbas
Thank You Very Much. On Nov 28, 2013 10:39 AM, "Shaikh Vasim" wrote: > Okies, > > > Go to Developer - Visual Basic - Select the sheet (you want ro hide from > the VBA project box) > in VBA editor - View - Properties window > in Properties window box - Visible (last option) and change it from > dr

$$Excel-Macros$$ Hide to excel sheet

2013-11-28 Thread Ali Abbas
Dear All, Hope all you well...plz tell me how can we hide excel sheet permanently which no buddy can un-hide, amd how can we hide xl sheet which no buddy can see with unhide option. Thank Tigarman007. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:

Re: $$Excel-Macros$$ Max Array Formulla

2013-11-04 Thread Ali Abbas
Ok boss I will share the file with you but I cannot use the Pivot Table in this my work situation. On Nov 4, 2013 3:15 PM, "ashish koul" wrote: > why don't u use pivot table also can u share a sample file > > > On Mon, Nov 4, 2013 at 8:33 PM, Ali Abbas wrote:

$$Excel-Macros$$ Max Array Formulla

2013-11-04 Thread Ali Abbas
I need a maximum array formula which can calculate maximum value in a single column, but any unique value repeated again and again in the column. Need is if "a" comes 5 times ,"b" comes 7 times than this formula calculate highest value of "a" and "b"which are in single column. Plz plz -- Are you

$$Excel-Macros$$ Formula for calculate max number for unique values

2013-11-04 Thread Ali Abbas
On Nov 2, 2013 9:03 AM, "Ali Abbas" wrote: > Dear All, How can we develop a Formula for calculate max number in unique > values like if we have 1000 total values and 10 values are unique in this > data. I have needed a single formula which can calculate unique values max >

$$Excel-Macros$$ Formula for calculate max number for unique values

2013-11-02 Thread Ali Abbas
Dear All, How can we develop a Formula for calculate max number in unique values like if we have 1000 total values and 10 values are unique in this data. I have needed a single formula which can calculate unique values max number (problem is all 1000 values in a single column and their number in ot

$$Excel-Macros$$ VLOOKUP doubt

2013-09-23 Thread Satiqjaffar ali
Hello experts, I have some doubt in VLOOKUP, that how can i get lookup value from previous cell?. please find the attached sheet and advice.. thanks a lot. Thanks Satiq -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook pag

Re: $$Excel-Macros$$ Sum if array for cut dates

2013-08-22 Thread Ali Abbas
dear sir formula not work plz help. On Aug 22, 2013 5:34 PM, "Ali Abbas" wrote: > thanks brother > On Aug 22, 2013 4:14 PM, wrote: > >> ** >> You can use sumproduct also >> >> =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b) >> >> Assumin

Re: $$Excel-Macros$$ Sum if array for cut dates

2013-08-22 Thread Ali Abbas
gt; Sandeep > Sent on my BlackBerry® from Vodafone > ------ > *From: * Ali Abbas > *Sender: * excel-macros@googlegroups.com > *Date: *Thu, 22 Aug 2013 23:31:14 +0800 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *$$Excel-Macro

$$Excel-Macros$$ Sum if array for cut dates

2013-08-22 Thread Ali Abbas
Date: 1 2 3 4 Amount: 100 200 300 400 Now formula working. We can calculate value with array sum amount if date 1 to 3 then answer is 600 but if we change date scenario and mention date in cut day like sum amount if date is 2 to 4 then its answer will be 900 but how can I make th

$$Excel-Macros$$

2013-08-22 Thread Ali Abbas
Dear all. How can we calculate a array function for sum amount or any figure for cut dates like sum if( 12 feb to 20 feb) -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discu

$$Excel-Macros$$ Re: This Formula to span number of nights (from Date of Arrival to Date of Departure) not working!

2013-07-12 Thread Ali
Thank you again De Premor! I was struggling to find out what was wrong with the formula! :-) Love this forum! On Thursday, July 11, 2013 9:16:27 PM UTC+4, Ali wrote: > > Hi all, > > I recently posted a topic to solve an issue regarding the span of total > number of nights sp

$$Excel-Macros$$ This Formula to span number of nights (from Date of Arrival to Date of Departure) not working!

2013-07-11 Thread Ali
Hi all, I recently posted a topic to solve an issue regarding the span of total number of nights spent in specific columns. The forum members were really helpful, particularly De Premor! Link is here: https://groups.google.com/forum/#!searchin/excel-macros/Formula$20to$20span$20number$20of$2

$$Excel-Macros$$ RE: Macro Staff Hierarchy

2013-06-30 Thread dii ali
HI all, Is it possible to do the attached in Vba / Macro. Any help would be appreciated Dii -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www

$$Excel-Macros$$ Re: Formula to span number of nights (from Arrival Date to Departure Date) in relevant monthly Column

2013-06-25 Thread Ali
Thank you De Premor! Works beautifully! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ Formula to span number of nights (from Arrival Date to Departure Date) in relevant monthly Column

2013-06-24 Thread Ali
XT(D$1,"ymm")=TEXT($B2,"ymm"),IF(TEXT(D$1,"ymm")=TEXT($C2,"ymm"),$C2,D$1)-$B2+1,IF(TEXT(D$1,"ymm")=TEXT($C2,"ymm"),DAY($C2),IF(AND(TEXT(D$1,"ymm")>TEXT($B2,"ymm"),TEXT(D$1,"ymm") > Excel attached > >

Re: $$Excel-Macros$$ Formula to span number of nights (from Arrival Date to Departure Date) in relevant monthly Column

2013-06-22 Thread Ali
Departure on 30-01-13). Is there a way to twist the formula to account for this issue? On Thursday, June 20, 2013 12:02:23 PM UTC+4, Vabz wrote: > > Hi > > PFA, there are other solution for this. > > HTH > > > On Thu, Jun 20, 2013 at 11:53 AM, Ali >wrote: > &g

$$Excel-Macros$$ Formula to span number of nights (from Arrival Date to Departure Date) in relevant monthly Column

2013-06-19 Thread Ali
Hi all, I have a worksheet that need to allocate the number of nights spent by a guest in the relevant Columns designed for the purpose. I can't seem to find the right formula to do this. Here is a brief of the situation and the problem that need to be solved: Column B has the Date of Arrival

Re: $$Excel-Macros$$ Short cut keys for unmerge cells in excel

2013-05-23 Thread Ali Abbas
thanks my dear, May Allah Bless On You. On May 23, 2013 10:57 AM, "Prabhu Pinky" wrote: > Hi, > > try the key combinations* Alt+H+M+U* to Unmerge and *Alt+H+M+M* to Merge > the cells. > > > Regards > Prabhu R > > On 23 May 2013 15:28, Ali Abbas wrote: &

$$Excel-Macros$$ Short cut keys for unmerge cells in excel

2013-05-23 Thread Ali Abbas
Dear All, any one know how can we un-merge cells in excel with short keys Or have a any short keys for unmerge to cells -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discuss

Re: $$Excel-Macros$$ Need Matching excel formula

2011-05-28 Thread Arshad Ali
Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><&

Re: $$Excel-Macros$$ Need Matching excel formula

2011-05-28 Thread Arshad Ali
pot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><&

$$Excel-Macros$$ Excel Mobile Application Reader

2011-05-08 Thread Juma Ali
somebody open it for me, copy the contents in the file and send me the contents of the file while open. Thanks in advance. Juma Ali juma_...@rocketmail.com This Email was sent using an Inbuilt Email Application of a Sony Ericsson W910i cellphone

$$Excel-Macros$$ Excel in Safe Mode

2011-02-07 Thread MD ALI
Hi All... When we use Excel in safe mode? What can we retrieve from excel safe mode? Can you provide the merits of safe mode in Excel? Can Someone clarify my doubts? Thanks alot -- Regards, M.Md Ali. -- -- Some

$$Excel-Macros$$ Excel Macro Help

2011-02-07 Thread MD ALI
Hi all, I wanna learn Excel Macro. Can someone help me or provide step by step procedure in pdf file to learn it? I dont know anything about Macro. But I am eager. Appreciating your help in advance. Regards, M.Md Ali

$$Excel-Macros$$ Error Message when opening a file

2011-02-07 Thread MD ALI
Hi Everbody, I have faced a problem when opening a file. During opening it shows error messages that "Not enough memory to run Microsoft Office Excel. Please close other applications and try again". I already tried to solve it by re-installing the software. I couldn't solve the solution. How can

$$Excel-Macros$$ Excel concatinating string with variable

2010-12-06 Thread ali
Hello, I would love to know from some guru an easiest way to do the following; I am making an automation with the help of Macros, I stuck on the following point. Through the macro I want to copy a range of data from one sheet [POF] to another [Order]. Range("E24:O20") but not simple as this, t

$$Excel-Macros$$ Pivot table with a twist

2010-12-01 Thread zeeshan ali
Hi all, I have to print salary slips and bank transfer letters for 600 employees at each month end. I have created a database in excel linked to word mail merge so it is easy to print salary slips by selecting the relevant fields. However, salary transfer letters had to be created by linking each

$$Excel-Macros$$ Macro Help

2010-10-17 Thread Chaudhry Zahid Ali
Dear All, Please find attached a file. It contains four sheets. Sheet branches contains details for branches, sheet data contains data for the branches and sheet report contains the rough format in which I need the report to be in. My quest is that when ever a new branch is opened, for example, b

Re: $$Excel-Macros$$ Arithmetic with blank cells

2010-07-31 Thread Shujaat Ali
Woopss... Sorry for in-complete formula: keep the formula as =if(C1="",0,C1) regards, On Sun, Aug 1, 2010 at 8:39 AM, Shujaat Ali wrote: > Hey, > > soemthing i would use, simple and easy, if its fits :) > > simply take another (any) column with the formula of

Re: $$Excel-Macros$$ Arithmetic with blank cells

2010-07-31 Thread Shujaat Ali
Hey, soemthing i would use, simple and easy, if its fits :) simply take another (any) column with the formula of Val , for example: C1D1 10 =val(C1) =val(C2) and so on. and simply take the sum of Column D. hope it helps. Best regards, M. Shujaat Ali

$$Excel-Macros$$ Pivot Problem

2010-06-20 Thread Chaudhry Zahid Ali
Dear All, I have to apply pivot on a data that reaches approx 1.5m rows and is spread on 15 columns. If I divide the data in two parts of 0.8m rows each, I can not do a complete analysis. Any suggestions?? Regards, ZAC --

$$Excel-Macros$$ Macro Required

2010-06-19 Thread Chaudhry Zahid Ali
Dear Group, I have excel sheets containing sales data on daily basis (from about 150 sites) (The columns are similar in all the daily sale files but rows change from time to time as new sites either become operational or stop working). I wish to consolidate all the data in one excel file in such a

Re: $$Excel-Macros$$ Formula Guide Require !!

2010-05-04 Thread Chaudhry Zahid Ali
Thanks Shayam for the link to the great site... But does anyone knows any site from where I can download the details of these functions.. I want to read them at my leasure time at home as it is impossible to go through them during the office hours.. Thanks ZAC On Tue, May 4,

Re: $$Excel-Macros$$ Urgent Help Required in a macro

2010-04-21 Thread Chaudhry Zahid Ali
Thanks a bundle Dave. This has expedited my work even more. :-) (P.S) Can anyone refer me to a good course from where I can learn to write macros... On Wed, Apr 21, 2010 at 4:31 AM, Dave Bonallack wrote: > Hi Zac, > Can I suggest a simpler approach? > Using the Ctrl key, select the 2 cel

Re: $$Excel-Macros$$ Fwd: Urgent Help Required in a macro

2010-04-20 Thread Chaudhry Zahid Ali
ogic based updation of data is possible and someone in group should > help you out on same, Please submit a separate query with detailed example. > > > Best regards, > Ayush Jain > Group Manager > > On Tue, Apr 20, 2010 at 8:38 PM, Chaudhry Zahid Ali < > chaudhry.zahid@g

$$Excel-Macros$$ Urgent Help Required in a macro

2010-04-20 Thread Chaudhry Zahid Ali
Hi Group, I'm working in a huge excel sheet with thousands of entries. I am currently looking for a macro, that when invoked (upon press of a key etc) would open a dialogue box having three fields. The first field being Select Row, In which I can write a row number Like 3, the second filed would c

Re: $$Excel-Macros$$ Re: Pivot Problem

2010-04-14 Thread Chaudhry Zahid Ali
ask. > Access can handle larger database queries. Even if you use Access to > perform all your summerizing and then export it back to excel for the > presentation parts, I think you you come out with far less stress. > > -Good Luck > Michael > > > > On Apr 12, 2:41 p

$$Excel-Macros$$ Pivot Problem

2010-04-12 Thread Chaudhry Zahid Ali
Hello Group, *Overview:* I have a issue to discuss. I have got an excel sheet which contains over 150,000 trial balance account subheads made up of data from different branches (All Branches). So there are multiple account heads that are repeating. I have constructed a Pivot table out of the data

Re: $$Excel-Macros$$ Concatenate, including blank fields

2009-11-23 Thread Shujaat Ali
t;<><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009

$$Excel-Macros$$ Re: Need to copy file name to XL.

2009-06-30 Thread Shujaat Ali
nt name to get populate in the B2 coloum >> of an excel and all the file names to be shoted alphabetically. And also the >> file path should get populate from C2 column. >> >> >> Thanks in advance, >> >> >> Regards, >> >> Kunal Rout >

  1   2   >