## dalmia

Using Sumifs, pls calculate total Item received by each warehouse and the amount of item received by each ware house …

Using Sumifs, pls calculate total Item received by each warehouse and the amount of item received by each ware house …

I need a formula that will search a specific cell (E2) or all of column E for a “key” word and then if found, take the date in A2 and add 30 days …

How to remove unwanted caracters Â£40.90 -Â£12.00 and format into numbers or currency format. Operting System OS latest version …

excel 16 mac array formula if values in column A = values in column B move corresponding value from column C to column D By:

Hi, I am not sure if this is the appropriate place to ask this question. I’ll go ahead please indulge me. In my Pivot, i have several questions that have …

I am trying to figure out how I get a total from the data that I have in my chart. I already sorted it by name and type. But now I need to see how many there …

Hello,I want part of the text below 1398/12/30 in a cell with a format or code or any other tool … I would say exactly 30 so that the text of 1398/12/30 …

I need to present to others a proposal on investing in some equities and bond funds and discovered that different functions return different results using the …

Hello I am using excel 2013 and I need assitance. I have a exel sheet with over 2,000 people listed by their names and what counties they live in. I need help …

Good Evening, How do I create an excel document that auto populates to a microsoft word document? I recieved an excel document that allows me to input …

Hi, I have been tasked with organising data by my boss. I am not 100% sure on how I will achieve it using excel, if someone can point me to what function …

So I have 2 excel sheets. I need to match data from Sheet 1 in column C to data in Sheet 2 in Column B. They are not in order. I am looking for axact names …

Hi, I have a column of over 200 rows. I would like to identify all the cell locations within that column that have the value of “0”. I know the …

I am trying to reference another workbook in my excel file and I am trying to use the hyperlink function. The code does not output an error, but it results in …

Would like to have computer’s current date and time automatically appear in a spreadsheet, in column A and on the next row, at each instance that a …

i want to have a number on excel that increases as a function of time (i.e. the number increases as time increase. I’m going to set this number to be …

I am trying to make one function for my work for a while and cant rly get it done. Basicaly i have two columns . First column are names of the items. …

Hi, My problem is that I have two tables and one table that is combining (adding up) the two tables together and I want to be able to sort all 3 tables …

I had face some problem if funtion what does mean and how to formula create…use a logical function to find out if each customer is eligible for a daily …

Hello, Please advise how can I consolidate multiple columns for each row. Example: Multiple employees have taken multiple programs each. How do we consolidate …

I have made a watchlist of shares in which I m trading on moneycontrol.com website . I want to transfer these shares details and stay connected with share …

My problem is based around an excel sheet being used to produce rotas which are then stripped to submit payroll hours. There are names of people on this …

I will do my best to explain what I’m looking for – I hope it makes sense! I have included a bit of my worksheet so you can hopefully understand …

Hi everyone, I am struggling with the following. I have a lookup table called LookupTbl which consists of keywords in column A and then a category …

I have stumbled across a small issue which I can’t seem to overcome. In column A, I have a list of amounts for example Column A 234.34 2286.59 100.00 1286.48 …

Hello All. I want to have an out put with variable number of rows in Excel. I want to enter the number of rows (consider as number of year of a life insurance) …

I would increase the Date(2018-03-04 08:00) by given number. Ex. Cell A1 (2018-03-04 08:00) Cell A2 (48.20) ///Number as hour and minutes which in …

Hi everyone, I would really appreciate if someone could help me regarding a function I am trying to execute on Excel. By:

I am trying to set up a spreadsheet into which I can dump a month’s worth of appointment dates, times, and visit durations for a variety of people. I …

Hi. Can anyone help I am doing a schedule and need to work out the duty period for the employees. This formula needs to be able to match the name …

i want to sum the costs from my journal to general ledger but i want them to come under their own head =ifsum(D4:D20,”D4=A1″,G4:G20) as i have so …

So I have a data set like 1 a 1 e 1 a 2 s 2 s 2 s 2 s 31 e 31 w and I want the output to correspond to max frequencies of text for each unique index. The …

Hi, hoping this finds you well. Kindly see the table below, I have some excel data below Vehicle DEFECT Date KAB 336D Oil Leak 3-Jan-18 KAC 340C …

Wow, she is one of the most beautiful girls I have seen http://www.youtube.com/watch?v=xmxdAu6RQtMBy:

The last row of my table is a total row, in which I’m trying to calculate the sum of squares of the ‘Distance’ column. Since there is no …

Data Model connecting several worhseet sheets into one table was used in Excel 2016. After creating the pivot table, I realized that there were spelling …

Dear All, I’m pretty new to Excel and appreciate any guidance regarding the following issue that I encounter; In the following, I have a row (in …

how do I use if function to see if an appointment can be made at a specific date and time. So basically If I have a sheet of previously made appointments and I …

Dear reader, The Matrix below shows the distances between different cities in Poland. I have a dataset with courier services where the recipient city and …