## Clerk

Hi, I usually use 5 Workbooks (Week-1,Wee-2,Week-3,Week-4 and Master) but for this example lets use “Week-1” and “Master” workbooks. I …

Hi, I usually use 5 Workbooks (Week-1,Wee-2,Week-3,Week-4 and Master) but for this example lets use “Week-1” and “Master” workbooks. I …

I have a situation where I have 3 different “categories” but 4 differernt formulas. SO, let’s say my categories are Dogs, Cats, and Fish. I …

Hi, Not sure how best to explain this but here goes: I need to marry two sheets, the one sheet has the names of the customers and billed amount (Sheet 1) and …

We use modified pivot tabel syles – does the grand total format always override the row subtotal formats or can I change where they overlap? Youc …

Hi, This is my formula its currently pulling volume information by period from a workbook into this workbook, I need add another level to say just bring …

Attatched is an example of what I am working on. I am trying to figure out(in VBA) how to sum TrksReq in column B based on plant number in column A. The sum …

I am working with a listing of 10 and for each I have 6 columns – last name, first name, SS#, Salary, Date of Hire, Department. I want to create reports …

Hi Ladies & Gents I’m hopeless at anything beyond the very basic formula and would like help with the following if poss please: I have a huge …

How to increase a number from a text and number combine cell ? In column A I have several kinds of codes which are duplicate. Now I want to make …

Dear Excelgeek, I need your help to make formula for my study, here is the result table: Male Result Age Very Good Good Fair Poor Very Poor 10 …

I have eight different product numbers with unique descriptions and prices. In order to reduce or eliminate order entry errors, I would like write a formula …

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

Ассоциируется с бездной, холодом, космосом, пространством так.By:

I am trying to create a pattern in excel, all in one column..ie. Notice the pattern below. I want to automatically continue this pattern all the way to …

Hello – I have a spreadsheet of data (Excel 2016) analyzing newsletter results for our firm. Column A has client email addresses and each …

What does it mean when your speadsheet shows Sheet1(4) on the bottom??? What does the (4) mean?? and how do I get rid of?? By:

I want to track document log where I want to get Auto update of Status as “OPEN” or “CLOSED” by inserting document submission date and …

I have two Columns In column A: Athere is date In column B:B There are events that will occur on the date which is in A:A Now I just want get get …

Hello, I have two individual tables on the same spreadsheet. I would like to use multiple filters from both tables, however every time i select the …

the data: 9/1 9/2 9/3 9/4 ~> 9/30 group b x x x x x group b x x x x x group a x y x x y group c x y y y y group c x y y y y group b x x …

hi, i have a question at excel. if you can help me?? i need to do data analysing graphs from excel, and they look more or the less the same like this one. and …

Hello there! I’m new to excel and I’m stuck in sorting some data. I have an excel sheet containing data of some companies which are selling …

The table below is an extract showing the responses to Class preferences. I want to run a formula that gives me a column with choice 1 and another with choice …

Hello Team, Please help me to solve below; Q. Conditional formatting to highlight numbers 20% above overall average and 20% below overall average in given …

In cell B11 enter a formula using relative cell references that adds the values in range B4:B10 – I am not sure is it =B4*B10 or =B4+B10 …

Hi guys, hopfully someone can help! I have made a simple version of my problem below: a 5 …

Hello There, I am PhD student and working on some traffic counting cards, the card has 2500 rows and one column, the column has numbers from 1 to …

My example data here is what I am looking to get for an end result without having to go in and manually change the column letters on each row as I have been …

Is there a way to count all the A’s in a column and also use an else, space =COUNTIFS($Q$19:$Q$48,1) is the formula I’m using. When …

Colomun A has one Date Column B has a later date What is the correct formula to figure out the days in between e.g COLUMN A …

hello i need code in formatting conditional for example column A: odd row 15 rows color: yellow next 15 rows color: red next yellow next red to last row …

I am creating a spreadsheet for chemicals concentration and I want to look up a certain chemical name but I want it to look throguh a table of different …

The data acquisition of a machine I’m am working with puts all data into a csv file. Most of the time it is separated into the relevant headings but some …

I have data set, in which some coulums have real measured values and some column have reference values . I want to delete column with reference …

hello, i have a protien code file, and i have the protein structure (writen as a word(cube, uup,..) ) in the first column A, and the sequances realted to …

down votefavorite I have a workbook with multiple sheets, in each sheet I need to copy the same row contents to my master list. I have a code to …

I have some data I wish to sort into a list BUT… in column A are vendor names vertically i.e Tradesmart and then horizontally across the top are …

Hi, please assist. I am running excel for mac. On the windows side, I have a program running, it populates a .csv file. In the the .csv file, lines are …

Hello, I am having a SUMIFS problem. I have uploaded a screenshot of what I am looking at but here is the description:Goal: To display a Sum value of Column …

Ho can I get Call Outcome for last calling date thrugh Number from below table. Call Date Number Call Outcome 1-Aug-17 123 Not Interested 2-Aug-17 456 Ringing …

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.