## E-learning consultant

How can you delete numerous records on a filter without deleting every record in between. Say we have 40k records and we want to put a filter on that displays …

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

How can you delete numerous records on a filter without deleting every record in between. Say we have 40k records and we want to put a filter on that displays …

how to create a drop-down list of names that will update the chronological order based on the name selected for multiple columns? By:

I have a txt file that is exactly 500 characters wide and can have several thousand ‘rows’ of data that are also exactly 500 characters wide. …

Hi, I am looking for equation in excel which subtract 4 from different numbers so as to get a reslut rest number “not in minus and zero” …

i would like to calculate the following: if any value is entered in 1 cell then the corresponding cells value should be -1 By: Eric

Hi, I need help in creating a multiple if statement with text & a wildcard. I have an existing formula that works, here, …

I am trying to count uniques values in a column (say Column A) so not to include any duplicates. However I only want to count the values if the month in a …

I have one employees exel spreadsheet with location data. I have a second empployee excel spreasheet that lists if they are management level or …

Hi, I am working on a file where i have to make sure that two columns have the same data. The issue is that the data is not arranged in the same order in both …

Hello, If anyone could help me with this, I would greatly appreciate it. I am looking for a formula that will help me with the following situation. I …

Hi I have a question about how do I explain a negative percent for sales that is positive compared to negative sales the prior year? Last sales was a …

Hi I have a question about how do I explain a negative percent for sales that is positive compared to negative sales the prior year? Last sales was a …

I am trying to build a spreadsheet with a table recording monthly (rows) business takings by year (columns) that will apply conditional formatting (red and …

Hello I have a table in excel like this: A | a B | b A | w B | z I want to transform it into: A | B a | b w | z Is there any way to do …

I am trying to write a function that has a black out in time. Currently G4 displays a time that text was entered into F4. In the next line, I …

Hello, I have a list of part numbers in column A on sheet titled NC Programming along with data corresponding to that part number in the following …

Hi I need help working this out A Delivery Fee of $2,000 is charged if the delivery is 100km or closer. If the distance is more than 100km …

I have a sheet with two diffrent columns that display two diffrent prices. I want to sort the sheet by these two columns so I can see all of the prices that do …

Hello , I am new to VBA . I am trying to select filtered data from work sheet (Emp_id) and paste it into worksheet All_emp. I am filtering …

Hi, I have a workbook with a lot of data. I’ve created a 2nd workbook that references the data in the first. I do this so I can share that …

I have two columns, one with a name and one with an item. There are sometimes multiple names for the same item and multiple names with different items. I am …

I have a worksheet with all 50 states in column A, and the names of cities in those states listed in columns B through AZ. I would like to change this so …

Hello, I have a large table where my numbers are in the scientific notation x10^ format (I used a formula to convert the Excel E scientific notation …

Hi, I am doing a spreadsheet and I need one column (D) to go red and say “Not Ready” if any of the 7 other cells (E to K) in that row are …

I need to find out how to place a bottom border ONLY on each row of a table that is 20 columns by 1000 rows in size. How can I get this with less than 5 clicks …

Hi, I have linked two workbooks and have runa frmula but when I try to copy the formula don is just stays specific to initial cell I put in the …

i have bunch of text on sheet. i must find word that ends with ‘owa’, ‘ow’ and ‘ew’. and copy that finded words to another …

I have created a custom list for a slicer with the questions in the order I want listed. When I save and open on my computer it remains, but if I save and …

Hi, we want to make Project tracking table that will autofill cells with color based on the data inputed into a table. The table is simple, its 2 columns and …

I have a workbook with three sheets. Each sheet is an assignment tracker for each of my managers. Their assignments are prioritized by either a 1, 2 or 3. I …

I have a workbook with three sheets. Each sheet is an assignment tracker for each of my managers. Their assignments are prioritized by either a 1, 2 or 3. I …

I use the following formula to calculate days between dates: =IF(H452=””,”Not …

Excel novice here. This may be very easy, I could be doing the wrong math. I’ve made a spreadsheet to track dollars and other sales levers per hour. …

I’m working on a spreadsheet where I would like cells to be highlighted if the date in the cell is 30 days or greater from today’s date. …

What I …

I have a spreadsheet with 3 columns. Columd (C) has all negatine numbers in it. I want to add a nhew column (D) where I can enter a value and want it to deduct …

I have two cells which has functions which will give me results as OK or reason for the error, And I want to have third cell to complare both cell and if not …

I have a column where some have £ amounts … how do i get a total sum to pick out only numbers with a “£” in front? By: John

I want to create a single formula that combines the two formulas together: =IF(E1>500,500,E1) and =SUMIF(A1:M10,”Y”,E1:E10) Basically, I want to …

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.