## If/Vlookup Help?

Hello – I am wondering if it is possible to create an IF/VLOOKUP (or something similar) statement that does the following: There could be 2 rows …

Hello – I am wondering if it is possible to create an IF/VLOOKUP (or something similar) statement that does the following: There could be 2 rows …

My data (test scores) are located in varied cells according to the year when the test was taken, like this: …

Hi…I was wondering if someone can help me out. It would be very much appreciated. I want to create an excell sheeet with some drop downs and add a …

Is there any way to take this formula or a variation of this formula and have it drag and change the months so that my formula stays the same but the months …

Hi, So my question is say if I can set a control in sheet 1 to define date May 4th and May 5th as week 1. May 8-12 as Week 2 and so forth. I want that as …

hi, i am unable to build farmula in some situation, when i use vlookup function it always pick 1 value how do i get rid of this problem. …

Hi, I’m a triathlete, and I’m trying to create my own training log. I’m stuck on one cell. I need a formula to calculate my swim pace per 100 …

Excel 2013 not shown so please note I use 2013 The number in question is 600,000 the %’s are as shown. Assuming each % of the number is correct …

This code is used to rearrange scattered data in many tables. In the line having comment, the run time error rejects extracting the row of loop variable D, …

Item Profit Basketball $ 10.00 DVD $ 12.00 Football $ 10.00 …

Hi I need some help. I want to put in one column for example 5 times letter X (in two rows) X X X X X X X X X X and I want to have Sum of them (or count) to …

I have a spreadsheet containing many thousands of rows extracted from a document management database. Each row has multiple columns. Across those colimns …

Can you please help me for a formula in this example… in the Final Code, i want an answer in A2 If B2 has an answer, then A2 is = to B2 if B2 has …

In excel solver,i need a variable to either be zero or lie between 50% of max to 100%. i.e it should not lie between 0 to 50% but can be zero. how to add a …

I have a problem I am trying to solve. I have a list of names in one column and the corresponding emails addresses in another column saved to a workbook …

Everyday I pull up a report indicating when someone took a course for my work. Instead of pulling up in chronological order, the report shows the Day of the …

I would like a macro that does the following: It would look in a specific row and find the cell with the largest number in this row, and then inserts a …

/* Style Definitions */ table.MsoNormalTable {mso-style-name:”Table Normal”; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; …

I am trying to conduct a weighted evaluation on different services. The top mark for each offering by this service is 1.00. My likert scale is 1 = very poor, 2 …

Hi I am looking for a formula that will look at all cells in all sheets and if any have the value of 0 it will display the name of the tab tat contains it. Is …

How to calculate the amount of raw material usage within one month in a restaurant for example: Salmon Soup: 50g of salmon 20g of egg …

I wish to colorize rows conditioning by two columns, e.g., D is date formatted and E contains some plain text, and I want to find out those rows D is earlier …

I use Excel quite a bit and work with very large data sets. I know that you can select a whole column by clicking on the very top of it. However, …

If you take (A1-A2)/A2 , what does this formula give you? Let’s say you’re doing a YOY comparison, if A1 is April 2017 and A2 is April 2016, would …

Hi I have daily operation report and i am trying to make summery sheet from the daily report so i need to know how i will make summery by select date and …

Whilst I have been using Excell for years my question probably shows I don’t understand many of its intracasies. My operating system is Windows 10 and I …

I have A 20X20 matrix. conditional formatting is made to this matrix which is linked to a spin buttons. I entered this …

Hello! I am currently working on a workbook involving inventory on each sheet. On my cover sheet I have a summary of all of the rooms where …

Hi, I have sales data in two columns as below & would like to convert it using VBA or otherwise into separate columns based on product sold, the products …

i am using excel 2007. Is it possible whenever i choose specific cells (i don t care how, for example by double clicking at them or Ctrl +left clicking) …

Good day. I am looking for a formula. On excel I have to match number 1 2 or 3 with 13 numbers with commas in 500 rows. Sample is the right line …

How to find the number of “she” in the IDIOM – “She sells sea shells on the sea shore” ANSWER-2 As the SHE in shells counts. Now …

Im having a little trouble with a code in excel vba. My goal is convert the following if statement to a VBA macro. The if Statement: IF(R8=“W”, …

I am wondering why I can not access my excel files from work on my home computer with go to my PC. I can access files from any other program but not from excel …

need help with formula where we subtract from one column and the other column gives results. here is an example of what i am looking for. 25 0 25 …

Hi, I hope you can help. I’m trying to create a formula (in cell C9) of my spreadsheet shown below whereby I can search all countries in the header row …

Hi, I hope you can help. I’m trying to create a formula (in cell C9) of my spreadsheet shown above whereby I can search all countries in the header …

Hi, I hope you can help. I’m trying to create a formula (in cell C9) of my spreadsheet shown below whereby I can search all countries in the header row …

I recently encountered something that seemed really crazy to me regarding a specific cell and formula. I was using Excel Online, so I suspect that is where the …

Hi,, Want to calculate hrs. if In Time is [10:00 PM] and Out time is [6:00 AM Next day]. I have tried =TIME(HOUR(), MINUTE(), SECOND()) – TIME(HOUR(), …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.