excel & ilogic

Good morning, I'm making a report with a summary sheet where the data must be displayed, I already made 1 column that works perfectly fine and other one that is not working properly. I have this formula...

All Question And Answer to save in "Sheet1) We Need Reference "Question" Sheet1 to Sheet 2 , Also need four Option reference data from Sheet 1 According Question Kindly make solution this query

Hi all, I have an overview like this: I am looking at four quarters for a year. I have a filter as well. I want to specifically hide the first three quarters somehow. However, please note that: 1) I cannot use a filter, because I often use a macro that wont work if a filter is on, and 2) I...

Hi, I have a workbook with multiple worksheets and table. I am trying to perform calculation depending on selected values in cell Column A. so in B1 I want the following to happen if A1=ID 1 then do the following calculation C1*exp(-0.5/4)*(22-C1), or if A1=ID 2 then do this calculation...

How can I add new Account manager after every 100 New client/New logo sale and add Engineer after every 80 New client/New logo sale. Customer Count Jan Feb Mar Apr May Jun Jul Aug Booked Revenue 36,299 58,039 40,913 48,523 51,007 52,337 50,968 50,938 ARPU 4,000 5000 5000 5000 5000...

Hi, I am trying to create a user form with multiple text boxes and checkboxes and one Combobox, this user form is used to update request for orders, from combo box user select an item and from check user can selectthe size and from textbox, user can enter the qty, till that everything is...

Autogenerate serial number according cell reference Number ???? I have try cell Reference : A2 =11 i try cell reference A2 to B3 , problem is B3 Cell value According Auto generate serial Number.

i need only one Column , how to remove unuse area in classics pivot table ????? Show me how to delete empty column formatting

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

Hi, am using excel 2007 version i just want a simple task getting confused how to do please help me thanks in advance my task is in one sheet have rows 1,2,3,4,5 in another sheet has a,b,c,d rows 12345 rows add to abcd equally i mean 1 has abcd, 2 has abcd, 3 has abcd it means 5*4=...

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...

@ How to match Two condition & show value ???? via formula 1 st table to match 2nd table data , Need Both Condition Match (1) Invoice No. (2) CHA , And Get Result After match 1st table

Query : " HOW TO COMBINE " ITEMLIST " & USE IN DROPDOWN LIST (Condition : Inclued Both table "Item list" * Both Table "Item list is different * BOTH TABLE ITEM LIST SHOW ON MY DROP-DOWN LIST . HOW IT POSSIBLE THIS ????? KINDLY SUGGEST RIGHT WAY TO SOLVE THIS QUERY. Note: I was make...

How to make Automatic serial number with text ???? Basic = A1+1 =2 Next level : 1) India Combination with text Kindly Help me.....

* how to Apply Condition Formating in Particular Cells At a time, (Condition : IF then " Available Qty " <1 to Highlight Cell is RED color). * This condition Apply but Not properly Working , Pleased help to solve this query, I try to use Multiple criteria using this condition formatting.

How To make Hyperlink >Workbook File > Sheet 1 (Particular sheet link) # i try excel file create other excel file to particular sheet hyperlink making...... Pleased help me