terms

Hi In my team we have a daily set of data which we need to analyse and send to the teams members. As the summary of analysed data is sent by email I want to send it in a way that the data has borders on it. In terms of columns, it goes from column A to L. In terms of rows, data will vary from...

Hello, I am sorting my accounting spreadsheet and using the formula IF(J4="30EOM",EOMONTH(C4,0)+30) which works, the problem I have is adding more If variables for this file, most customers are 30 days EOM, but some are 45 EOM, some are just 30 days, some are 60 days. If I can get the first...

Hi Everyone! I want to thank / apologize to everyone for being new to all of this and for your patience. This forum seems friendlier than the the others! We have a planning document that helps the social services system to prepare a foster child for permanent adoption. It’s an xlsm format...

I would like to create an audit report showing dates when values were changed and what those values were changed to, but only one row for each date the value changed. We modify payment terms for our vendors and the payment terms show up on the purchase orders (PO). So if we change payment...

Dear Excel Gurus I would be grateful for your collective thoughts on how to add days in school terms. I am sure it will be an IF(AND) scenario but can't seem to figure it out. We have 3 terms at school, each 8 weeks long, therefore 56 days. Students achieve various goals within each of these...

HI, I want to transfer data from one sheet to another sheet. The data in the main sheet has several tables and i need all data on the next sheet in terms of cities and corresponding variables.

Here is the scenario, We have an excel list of terms but we want to isolate those terms that are proper names of schools. In real life we want to isolate the proper name term from the following list cat dog Murry's school church Is there such a function?? Thanks!

I have a complex one In Sheet 1 I have a dynamic table of info which changes daily I have 2 fixed terms '' FINISHED_GOOD and downtimeparetoTable which are always in Column A but can move rows, it depends on how many products I produce, sometimes it can be 3 product other days it might be 20 I...

I have a list of terms in one sheet (Find List) I have a column of text data "Replace Data" in another sheet that I need to search for exact full words/phrases in the Find List and if multiple instances exist in the text data of Replace Data, I need to eliminate all instances of that exact/full...

Hi, I am trying to model my in- and outgoing cash flow and want to have them dynamically change when I change the payment terms. Any ideas? Thanks! <colgroup><col width="184" style="width: 138pt;"><col width="128" style="width: 96pt;"><col width="87" span="9" style="width...

Hi, Can you please help me with formula or function to find multiple terms and leave me with a value of those who doesn't have a match. Here is what I want to do: Column A abc.com/contents100 abc.com/contents200 abc.com/contents300 xyz.com/contents321 123.com/contentsaaa 123.com/contentsbbb...

Hi, In cell A1 I have detail like below: "Sale - I will give a towel" What I need is for an if formula to look for both terms "Sale" and Towel" in the cell, if both terms are there I need it to return "Sale1" If only "Sale" is in the cell I need it to return "Sale2" I hope this makes sense...

<colgroup><col><col><col span="2"><col></colgroup><tbody> hi, i just want to know how to draq a vlookup formula without same above cell value. i want as per the Terms. <colgroup><col><col><col span="2"><col></colgroup><tbody> Tran Code Customer Name Customer Code Payment terms Payment...

I have a MS Word template file called "Tailored Bespoke Terms Template 2017 v4.dotm" The code I have, opens this file. However when the code errors (I'm in the development phase right now), the file remains in memory. I'm looking for some code that will iterate through any open MS Word...

Hi All, I'm new to the forum in terms of posting but have searched around this forum for years for help with bits on Excel. I'm hoping for some help in terms of some formula if possible. I'm trying to create a timetable as such. I have a few days as sheets with different students names on and...

Hi, Please be kind. First time user. I've got a formula as below. It describes the simple pharmokinetics of dosage and response. On day 1, there are no terms to sum. On day 2, there is one summation term. On day 3, there are two summation terms and so on. More weightage is provided to w(i)...

I am attempting to use sumproduct to total how many times certain abbreviated terms show up in a single column. Sometimes there is only one term, other times there are a string of terms separated by a slash (/) mark. The terms are H, MED, DRUG, ALC, OTC, and UNK. For instance one cell might be...

Hi all i got a question where my Excel ability's are not good enough. my setup is like this. <tbody> A D E F G H I J K L M N O P Q R S V X AA AB 1 turn over Vat determent value 12 determent value 2 2 Customer Name debtor nr Feb Mar Apr May Jun Jul Aug Sep Oct Nov...

This is just a concept at this point, but I wonder if its even possible with Excel... Say that A1:A10 are filled with search terms - apple, lug nuts, house cleaners, car mechanics, lawn care, etc - the terms don't matter at this point. Additionally, in B1 is a location (a city or state name)...

Here is my Google Sheet, you can show your magic here. It would be great if you explain how your formulas works in layman's terms. Thanks!