turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- 158K Members
- 3,437 Online
- 38.7K Conversations

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

1582 Conversations

- Mark all as New
- Mark all as Read
- Pin this item to the top
- Subscribe
- Bookmark
- Subscribe to RSS Feed
- Invite a Friend
- Sort by Conversation Start Date

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Custom List Message Item | |
---|---|

Hi, apologies if this has been asked before but I don't seem to find the answer and if it is possible at all.
I have a spreadsheet with multiple tabs for a workload allocation (one per staff member). I want to create a summary worksheet and want the data ... Read More
Thanks for your reply, sorry didn't really make myself very clear - I think that I made it more complicated than it needed to be. What I need to know if it's possible wit...
Read More
Hey Machala-
Hope you're doing well. I saw that you had some external workbooks referenced in your workbook. If you are trying to reference external workbooks using th ... Read More | |

Hi | |

Hi all,
So I need to create formulae that will check the entire worksheet. So for example I need to be able to input all my product names and then have the stock codes generate automatically. So if "blue spotted dog" appears somewhere in the column, I want... Read More
Hi Melissa!
All you need to do is to enter the "Product Name" and "Stock Codes" in two columns respectively. Make sure that the product name should be unique. then you can ... Read More
Hi Melissa,
Sounds a bit like you need a VLOOKUP formula, but when you say check the entire worksheet do you mean check a column in a worksheet? Can you attach a small exam... Read More | |

I am trying to write a formula that would take the value in the space and give it another value. For instance, I have items in a row ranked from 1-3. If the value is a 1, I want excel to give it a value of 50. If it is a 2, a value of 25; and lastly, if ... Read Morecan you send the excel that you are working on?
i tried your sample in attached. | |

Greeting, first time to visit this forum, I would like to know whether excel has certain formula to resolve the following problem As variant that could be done with Power Query - first create a table for the conversion of points with 1000pt gradation and till possibly max amount of points (let say 5 ... Read MoreSee attachement.
In this file, you insert the ID and the spent dollars in column A and B. In column C D and E it counts how many of the biggest rate is applyable to the po ... Read More | |

I have two data sets that I need to compare. I am not sure if it is best to use vlookup formula. I have one spreadsheet of hospital cases with discharge date that I am trying to compare to a report of outgoing phone calls. Both spreadsheets have a unique ... Read MoreCan you send us a small example of the data you have? Use false names and dates and numbers, of course #GDPR
Then, I'm thinking about using RANK and/or LARGE to select th ... Read More | |

I am not sure if the COUNTIFS function is the correct method I should be using, however, I am trying to count something based on multiple criteria.
I need to count or sum the number of This needs to ... Read MoreYou can do something like this using a Countifs() formula like this:
=COUNTIFS(I:I,"End User",J:J,"Added ",B:B,"MI")+COUNTIFS(I:I,"End User",J:J,"Added ",B:B,"IL")
Yo ... Read More | |

Hi All
i need with a formula to do the following calculation 1 determine the quarter that a date falls in and then compare it to the last quarter of the year. 2. Determine the number of months in each quarter and then prorate an amount based on the number o ... Read MoreHi,
For the data structured like this
the formula in C2 could be =IF(3*RIGHT(C$1,1)-MONTH($A2)+1<0,0,IF(3*RIGHT(C$1,1)-MONTH($A2)+1>3,3,3*RIGHT(C$1,1)-MONTH($A2)+1))*$... Read More | |

When using the referencing or lookup functions, I frequently need to "capture" the name of a sheet. The function "Sheet" returns only the number of the sheet, even though a description says it returns the name. I need the name. An example: "VLOOKUP(SHEET(); ... Read MoreHi Jes,
Description doesn't say what SHEET() returns sheet name, it always returns the number of the sheet. You may use sheet name as parameter for the function, e.g. = ... Read More | |

I need help as to why all of my attempts to set a dynamic print range have no effect. I believe that my initial formula should work: =OFFSET(‘Customer Receipt’!$A$4,0,0,10+’Customer Receipt’!$G$10,8) I have tried other approaches, including VBA, and all ... Read MoreHi Michelle,
In general dynamic print area works if you set it that way https://www.myonlinetraininghub.com/excel-factor-5-dynamic-print-area Read More | |

I am hoping someone can help me. I am creating a personal workbook that budgets my disposable spending during a pay period. I want to have a column that shows what the average I can spend daily based on my allotted budget. As I progress daily through that ... Read MoreHi Aaron,
Could you please provide small sample file which shows how your data is structured, it will be easier to suggest the formula.
Read More | |

I am trying to make a budget spreadsheet to help determine personal expenses vs. savings. I have simple formulas adding income, adding expenses and subtracting expenses from income. Now I am trying to add a row for the balance in my savings account, in ... Read MoreIt sounds like you're running into a circular reference problem. Is there anyway you could provide a mockup of the example file you are using for this budget spreadsheet ... Read More | |

I need some help with a forumla;
I work in transport and I want to determine how many km's a particular asset has done, we already use a spreadsheet for loading records which includes the km's travelled for a whole unit (truck and trailers);
KM's appear i ... Read MoreRobyn-
Hope you're doing well. Would it be possible for you to put together a non-sensitive mockup of your scenario. Sometimes describing things in formula text can b ... Read More | |

Hi all,
For context, I'm attempting to total up the number of items in a given sales transaction. Each sales transaction is assigned a unique ID in Column O, with a new row for each item in the transaction. In my first attempt, I used COUNTIF to simply co ... Read MoreIf you change your COUNTIF to a SUMIF it will give you the quantity for each transaction ID. So in P2 enter: =SUMIF(O:O,O2,G:G)
| |

Hello,
I wish to calculate the percentage of a range of cells (column), but only if they have a value other than '0' (some lazy conditional formatting on my part). It pertains to calculating students were present (which I indicate with a 'P'). However, I ... Read MoreSo far I came up with this formula. Note that the range is a lot bigger, but the idea is exactly the same.
=COUNTA(($D$12:$D$211)-COUNTIF($D$12:$D$211,"=0"))/COUNTA($D$12 ... Read More | |

Hi, Everyone ,
My company has work shift from 26/01/2018 to 25/02/2018. And there are many events which is counted by this work shift. But When i use pivot table to calculate the event which is sorted by that work shift but the data is sorted from 01/01/2 ... Read More | |

I am using the formula below
=IFERROR(INDEX([170opscentre.xlsx]Sheet2!$C$2:$C$11,MATCH(B10[170opscentre.xlsx]Sheet2!$B$2:$B$11,0)),"") Works fine but is it possible to swap out the array (location on a shared drive) with a value contained within a cell? I ... Read MoreVLOOKUP($B2,INDIRECT(""&C$4&"!"&"B2:C12"),2,0)
By Above formula you can lookup based your values in cell. If you want to learn more basic to advanced level concepts the ... Read MoreHi Mark,
Yes use the indirect() function so your formula will look like this:
=IFERROR(INDEX("D1",MATCH(B10,INDIRECT(C1, TRUE),0)),"")
That should work for you.
Best Joe Read More | |

I am trying to set up conditional formatting on some dates in excel without much success. I would like any date up to 2 months from today in green, any date more than 2 months in amber and any date more than 3 months in red. Can anyone help?
Thank you Read MoreYou may use rule formula like =(A1>=TODAY())*(A1<=EDATE(TODAY(),2)) for two months, etc. | |

Please let me know what is wrong below function. =COUNTIF(ABC!A:A,"dog",ABC!Y:Y,"cat") Thank you. Hi Hirofumi
Countif can't have two conditions.
I've attached a spreadsheet that basically splits up the columns to calculate each.
See what you think?
Cheers Dami ... Read More | |

I've been asked to try to find a formula that will look for a duplicate of a number in one cell against a cell that has a "range" of numbers. For ex: I am looking to see if this number is duplicated " Is the range written in the same cell or it's in 2 near cells?
If it's all in the same cell, are all the numbers made of a 4 digits number, a + and a 2 digits number?
At ... Read More | |

Hey! I'd need some help. My goal is that whenever I write E3 in the marked area (I3:U69) I want the cell to become orange when K1 is true. Is there something I'm missing?
Thanks Read MoreHi Bjorn,
Rule formula could be =($K$2="E3")*$K$1 and the rule is applied to you $I$3:$U$69 range | |

Help needed with excel formula. I have an excel document with 4 sheets. I want sheet1 to add up data from sheet3. I want it to add up all the items in column D with matching serial numbers eg 123456 that are also shown as “open” in column I. Can anyone ... Read MoreHi James,
Could you please provide small sample file to be concrete with possible solutions. | |

Hello Everyone,
I'm a teacher. I have multiple classes. Some have 2 times 40 minutes a week, and others 1 times 80 minutes a week. Per 80 minutes I do 1 lesson (A lesson is 1 Tab in Excel). In each lesson (tab) I have space for 2 dates (for the 40 minute c ... Read MoreDo you already have an excel file to show us? I'm trying to understand exactly what you need and I don't want to waste your time (and mine!) working on a useless predicti ... Read More | |

Dear Sir, Could you help me to create new formulas for Column A (Scope), thank you. Detail as below : if the string of cable name include "CBL" or "EXT" then will show CKT on Column A (Scope), otherwise will show "AVEX". Thank you so much for help. Hi Justin,
It could be =IF(ISNUMBER(FIND("CBL",F2,1)),"CKT","AVEX") | |

I everyday update a Masterfile with the new people who have signed up for 5 different surveys and then I download all the 5 Individual survey files with their status and with the help of VLOOKUP, I try to put the status in Masterfile by matching their ID’ ... Read MoreAkash Singh-
This is certainly possible using VBA or Macros. You'll need to be more specific for the community to assist you in your endeavor. It would help to have N ... Read More |

Top Liked Comments

Share

Popular

Learning Resources

Programs

Values

- Contact us
- Privacy & cookies
- Terms of use
- Trademarks
- About our ads
- © 2017 Microsoft