## Calculate Multi-Look Up Product Formula

I would like to calculate a multi-point multiplication function and am having trouble. I am trying to do the following. IF the SUM of one column is equal …

I would like to calculate a multi-point multiplication function and am having trouble. I am trying to do the following. IF the SUM of one column is equal …

Hi everybody. I want to write a formula that gives me the value of a cell. I’ll try to explain: cell A and cell C have values 1 and 1, respeyively and I …

I have an excel file where comments show when you click on the cell. The question is how do I edit the comment. I tried going to Options, Advanced …

i want to a formula to rearrange RRP#56789LU to this RRP@LU56789 By:

-Do exact match lookup and approximate lookup use different functions? (Is it true or false?: Exact match lookup and approximate lookup use different …

Hello there! I need help with the VLOOKUP formula, can anyone help out? Many thanx in advance! I can upload a file, so it will make it clearer. Emanuela …

The spreadsheet is a swimming gala recording sheet. On the first tab the times are recorded freely as 12345 (where that actually is 01:23.45) I would like this …

I have two columns in my spreadsheet that use the same value, y. I need to find a way to highlight when both columns on the same row are empty of a y. I …

I have multiple columns of info that I need condensed into just one column. However, I also need that one final column to mention the info only once. In other …

Hi I have 2 sets of data. I want to tally the amount of times one is greater than the other. For example …

IF I HAVE TWO SPREADSHEETS AND I WANT TO FIND WHERE: IF VALUE IN “SPREADSHEET 1” COLUMN A MATCHES A VALUE IN COLUMN A IN …

НЕ УПУСТИ ШАНС РАЗБОГАТЕТЬ НА 7 000 000 ? СТУДЕНТ ВХОД 100 РУБЛЕЙ ВЫХОД – 699 600 ? СТАЖЁР ВХОД …

How can I have Excel count the cells in a given column which are each/individually less than the corespoding cells in multiple other columns? For example, …

Hi, sorry, exhausted all searches. I want a formula to tell me if the IF function result is the true or the false result. A very simple example, I have: …

Hi How do I do the following. I have a list of employee data for goals they have set throughout the year. I am trying to get data from one column split …

I have two cells and wish to dislpay diferent text in onem dependant upon the text in the other. Cell A1 usually has “result” dosplayed and cell A2 …

Hello I am working on airline revenue analysis dashboard. Where i need to find the top 3 airline carriers based on total revenue generated …

I have a situation where I would like to add a formula to a staff schedue that will calculate how many Room Attendants to schedule. A Room Attendant can clean …

hi, is there a way to make all excel files (xls) open with the same settings?more precisely I want all excel files that I open to have the same font, the same …

Assume the columns below start with column A: If you add up 23 weeks worth of 4’s, starting with column C (week 1), you will get a sum total of 92 …

In a sheet, I have some cells where I write formulas as strings and “add” them together for example: W13 = “=(50*1*963)+” W14= …

Anybody know of any code that would transfer an interactive excel worksheet to a windows 10 desktop widget. I have a live excel worksheet that refreshes data …

i need a formula to show a specific cell if anothe cell value is between 250 and 280 By: Francois

I’m not sure if this is possible, but it probably is but I just don’t know the formula. I’m trying to reference a tab in excel …

I have a spreadsheet with columns representing the months of the year. What I need is formatting to change the color of the font after the end of that …

Hello, i am having an issue running a macro within my excel work with. The person who wrote this macro no longer works for the company. I cannot seem to …

Hello In the format below, how do I display the numbers “Under” as “-” and “Over” as “+”? With + in …

I would like to use VBA to create a pivot table, where one of the column shows the “% of Parent Total”: is there a way to do that? Thank you in …

I recorded a macro in a workbook, and I would like to apply it to newly-created workbooks (created from SAS). I would like to just open …

Hi, I have the following formula: …

My question is if i have two excel sheets in one excel book,and i want to generate both the excel files in anotherexcel book .how to do.Both the excelsheets …

## we found a problem with some content in ” file name. xlxs” .Do you want us to try to recover as much we can? If you trust the source of …

Hello I have a small predicament with excel. I have produced the timetable for one week’s worth of classes (29th April – 5th of May) but I require …

Hi, I’m a beginner in VBA-coding, so this is probably an easy question… However, I won’t get my copy and paste VBA-code to work. It pops up …

i have 3 shifts A shift is from=6:00-15:00 B shift is from=13:00-22:00 C shift is from=21:00-6:00 excel should automatically …

Hi, I made Pivot table with four columns. First columun is ”ser.num”, Second, third and fourth column are months ( January, February and March). …

Hi, i have a data to sort by using linear interpolation. Let’s say i have Age Value 1 5 2 6 3 11 4 13 5 6 7 8 9 and 5 to 9 is given the only the …

I need the formula to combine column C with the number mentioned in column L26 to L32 By:

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.