## problem with excel

hi of the big excel spreadsheet, i only need the page which I can see and not the part where I scroll to the right. I only need to scroll up and down…how …

Excel 2010 Help. Free Excel help for formulas, functions, macros, spreadsheets and VBA.

hi of the big excel spreadsheet, i only need the page which I can see and not the part where I scroll to the right. I only need to scroll up and down…how …

i have a workbook which has multiple sheets, i am tryying to v lookup, what i needs in that i am making a data for the drivers working with me.. in my master …

Hi, I need a formula in Excel that lookup in a column of long list of values (texts) I created, then find and list all those texts that contain the specific …

Have excel spreedsheet mulitple rows over 300 have phone number in plain text with spaces, Need to search spreadsheet, apply formula …

I have recently put the companies jobcards on an excel sheet and sucesfully formulated all the time and breaks etc and then x it by the hourly rate. My …

Good day I am trying to create a formula based on two criterias ( which keep changing) these then should give different outcomes as follows: 1. For an …

Hi there, I have created a large spreadsheet and I was wondering if it was possible to create a formula where the value of a cell updates automatically based …

Hi I have three columns A B C. I want to put the data in column C that exists in either column A or B. Only one column in A or B will have data. …

I have a cell with a simple formula and I would like to round the result in the same formula in the same result cell. Example: =SUM(K16*1.03) with the …

Dears, I have a large number of data I want to distribute in a specific way Let me give you an example # The data consists of several columns with an …

ABCD 563 443 CLOSED 563 443 #VALUE! ABCD 563 443 CLOSED …

Respected, My scenario is as follows: Lets say I have 5 criteria mentioned in columns ( C,D,E,F,G) I have site names provided in column A I have product ID …

I am trying to paste in something from another sheet. I went to that sheet, copied the cells. Went back to the original sheet and, to make a row for the cells, …

I have 2 worksheets. One is just a templete of what i want to copy over from the other worksheet. The other worksheet has over 900 rows. i want to transfer …

I am using Excel 2010 and could you please help me with the following request. Suppose A1 to E1 each contains as follows: A1 CAT …

hello, I am having trouble writing out a lookup formula where if a certain text is located in a cell, then i want to look up another value in another …

Hello, I’ve been trying to search for solution for hours now, and yet still can’t find it. So I really hope someone could help me. So here is what …

I have a 2 rows in excel table.- 1st row is for Month and 2nd row is for score. The table is dynamic that a new month is added after every month. I need a …

Hi all, I have excel where I try to create graph based on certain values range. I use MATCH-function to create range based on date given in excel. For example: …

Hi everyone, I was wondering if someone could push me in the right direction regarding how to build a formula. I am looking for something to display …

Hello, I have a googlesheet not an excel (gasp*/sorry!) I have a data table that i’m extracting data using various if statements. I have …

My Data is like this Customer Id Date Product 123456 2/16/2018 Book 123456 2/16/2018 Book 123456 2/17/2018 Pen 123456 2/17/2018 Book 123456 2/18/2018 …

In sheet 1 column D if I put yes then I want to all data entered in Columns A, C, F, H, I, L exported to another sheet 3. After this everytime I enter …

i have 2000 Multiple choice questions with 4 options, in Excel sheet. i want to present them in Powerpoint with animation. please give some tips. …

I want to compare row and column values. My formula is =IF(A2=B1,1,0) . Next below cell formula would be =IF(A3=B1,1,0) and so on. Meaning compare the value of …

From TO 1 z q 2 n m 3 i l …

Dear Sir, I have created sheet1(Data_Entry) where data of employee training is entered, on sheet2 when i select a name of particular employee, his all training …

HELP i’m using multible tables in the same worksheet with some sum formilas and in each time I have to select the table I’m working with and print …

Can you please help me when I have problem like this.IF A =1, B=2 C=3….I=9If I have AB in A1 cell I want answer in B1 like “12” if I have ABD …

Hi, I’ve set up a spreadsheet to monitor the progression children achieve when on a reading programme but I’m having problems creating a sum to …

Hi I am looking for a solution to a problem in excel when trying to build a ss for a logistics company as followsIf column A has start point for a truckColumn …

I have downloaded a price list from our Sage accounting program in Excel format. My operating sytstem is Window 7 Pro and my Excel version 2010. …

=IF(SUM($K2+$N2+H2)-$M2<0,VLOOKUP($B2,’Container QTY’!$A$2:$B$219,2,FALSE),”0″) Hello – i am not sure how to …

Hello All, I have a quick question. I have an If statement which looks up a column in a sheet and takes that name and drops it in the cells, if the name …

Excuse me I have an excel sheet concerning fuel consumptions and supply containing the following: monthly average consumption weekly average consumptio …

Hello everyone, I’m preparing an excel workbook for a time report in which I have different operation codes in the following format: 1.1, 1.2, 1.3 …

Hi, I was wondering if you could help me! I’m a VBA Newbie. I’m looking use the replace function with the value in cell E4 in a sheet called …

Hello! I am using an excel spread sheet to track the inventory of award coins I am in charge of giving out. I know there is a formula function but I am …

I have a list of “Sales” .. each row is a sale with a new date. how can i extract on a diferent tab the list of dates (in order), that …

Hi, I would like to use the Insert Timeline function on a pivot table, but it does not appear as a menu option on my PivotTable Analyze tool bar. I am …

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.