Map Chart in Excel 365 does not identify himachal pradesh state in India
I am trying to build a series of heat maps for India providing some state level insights. When attempting to build a map chart, I realised that the chart doesnot identify Himachal Pradesh. Could someone please help me with this ? I used the following test data. States Number Puducherry 1 Lakshadweep 2 Andaman and Nicobar 3 West Bengal 4 Orissa 5 Bihar 6 Sikkim 7 Chhattisgarh 8 Tamil Nadu 9 Madhya Pradesh 10 Gujarat 11 Goa 12 Nagaland 13 Manipur 14 Arunachal Pradesh 15 Mizoram 16 Tripura 17 Daman and Diu 18 Delhi 19 Haryana 20 Chandigarh 21 Himachal Pradesh 22 Jammu and Kashmir 23 Kerala 24 Karnataka 25 Dadra and Nagar Haveli 26 Maharashtra 27 Assam 28 Andhra Pradesh 29 Meghalaya 30 Punjab 31 Rajasthan 32 Uttar Pradesh 33 Uttarakhand 34 Jharkhand 35 Telangana 36 I have added the file for reference too Thanks in advance :)
Copy visible cells only in 365?
The article says By default, Excel copies hidden or filtered cells in addition to visible cells. but when I copy filtered or hidden not included by default. Is there any setting for this in Excel 365? "If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells. By default, Excel copies hidden or filtered cells in addition to visible cells. If this is not what you want, follow the steps in this article to copy visible cells only. For example, you can choose to copy only the summary data from an outlined worksheet." https://support.office.com/en-us/article/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e
Need help on excel
Hi All, Need help if any can. I have a formula, I need to adjust the formula with criteria if in cell F6 "AR" so result of1st date of an array must come with 1st day of the left side dated month and rest should be the end of the month (Note if cell F6 is with AR Only 1st date should come with 1st date of the month rest should be the end of the month), if not AR all should come with the end of the month date. i am really thankful Regads Tariq
Userforms Excel MAc 365
Hola Amigos, necesito su ayuda... Soy desarrollador de aplicaciones en VBA Excel, tenia la licencia 2011 para mac, pero esta dejo de tener soporte, entonces adquirí el 365, sin embargo en esta versión en VBA no se pueden editar o insertar Userforms, a pesar de que si se ejecutan lo Userforms creados previamente. Gracias Hello Friends, I need your help ... I am an application developer in VBA Excel, I had the 2011 license for mac, but I am no longer supported, so I acquired 365, however in this version in VBA you cannot edit or insert Userforms , although if previously created Userforms are executed. Thank you
Help with excel formulas
Hi, I have attached 3 sheets in word doc . I have very simple one conditions that goes in main sheet column D8 1. =IF(AND(Sheet2!$E$2:$E$10000<=0.01,Sheet1!$E$2:$E$10000>=0.01),1,0) Issues I am getting is : I have to compare Roomids, Day Name and time slot to put correct values. How to match Roomids, Day Name and time slot in Sheet 1 and Sheet2 to Main Sheet and put the above formula? Sheet 1 and Sheet2 have similar pattern.
