formuals

Hi! I've been working on a report and I'm currently stuck on a section in which I'm trying to pull the qty order numbers are listed from one sheet and paste that qty on another. I've been trying to use formulas to make this work but i cant seem to get it done, I've used countifs, sum, and...

hello there, i would like to know if excel could apply search based on multiple condition and return a specific value that match with all conditions and there is the assumption. if i work in a bank and the bank sometimes do investigations to some customers to check their valid to have a credit...

Hello all - I have a question, please: Col A has values. Col B checks a condition and returns true or not ("Y"). If Col B returns TRUE, Col C stores Col A's value. Col D repeats the stored value so that: Col E can check Col D against a different condition, and returns TRUE or not. This...

Hello, Actually I have to update a master google excel sheet daily with numeric values. There are thousands of names across which value to be updated daily by datewise (new date in new column). Daily I get names with num values which eventually to be entered in their respective cell of a new...

Hi all, I currently have this setup: I have a row of formulas saying IF(ISBLANK(cell below),return blank value, otherwise return value to the left + 7) to advance the week one week ahead when data is entered. I want to create a conditional formatting for this row, so whenever a value is...

Hi Experts, I am working in a consultancy firm where I am dealing with different types of clients at the same time. I am using excel 2016. My concern is there any type of formula or any other function which helps me to check when I open and close the excel file includes all specifically day...

I am trying make a bar graph of the data shown below. The x-axis should be "Years" and the y-axis, should be "INCOME," "SPENDING," and "TIPS." In my attempt below, it can be seen that "TIPS" are not following the correct "Years" input. I created this graph be using the Graph Wizard in Excel...

Hello, Hopefully somebody can help me, I am trying to creating a sumifS formula or something I am looking to sum Qtys by date and item number from one sheet and match up to the item on a separate sheet: Sheet1 looks the following: A | B| C | D |...

HI can someone help. i have a formalu below =IFERROR(INDEX('sheet2'!$A$5:$S$32,MATCH('sheet1'!B19,'sheet2'!$A$5:$A$17,0),5),"") however when i need to add/dleete some columns in sheet2 and but i want it to stay and look at the above, but when i add/delete the columns the cells it is...

I'm looking to be able to run a vlookup or something similar that would check if the requested cells value is there but if it is then it should respond by showing the value of a cell from another column rather than the one it's looking at. What's the best way of doing this? Thinking maybe it...

Hi Friends, I am looking for help to convert values FROM: <tbody> 05-01-2018-01.15 </tbody> TO: 05/01/2018 01.15 AM Appreciate your help on this Thanks Khuharshree

I work with audit rules that are being populated from a financial database (Concur) into an excel sheet. There are different rules being applied to different organizations. I need to compare the overall data in sheet2 that has the names of the codes for the organization that are auto populated...

HI Guys Please see attached image re problem I have question written on image I have added the Spreadsheet here as well PLease can you help

So I am pulling out my hair here, trying to figure out why over the last two months, this formula has been working, and now it stopped. I have duplicated my previous work to the letter, I have double, triple, and quadruple checked my data sets. I have named and re-named my ranges to ensure they...

Good Morning, all. I'm a beginner with Excel and would like some help in figuring out the proper formula for the screenshot below. What I'm trying to do is be able to put in total Gross Profit for each day of the month and then have Excel tell me what I'm pacing to hit in Gross Profit at the end...

Hello My question is. I have a sheet lets say Called "Inventory" there I have 10,000 items with information from UPC, Name, Cost, etc. i don't want to use the sort for specific items so I created another sheet which I'll call "toilet paper" I want that this sheet should search in sheet...

Hi All, Please can someone help me on the below. Can a formula be used to pick up the different months in a quarter? Say I have Q1 in cell A1 and I want cell A2 to pick up the first month of the quarter, A3, the second month of the quarter and cell A4 to pick up the third month of the...

<tbody> Purple! Pink! Gold! Nude! Orange! Yellow! Brown Ivory! Black! Green! Silver! Purple! Pink! Nude Purple! Pink! Gold! Nude! Orange! Yellow! Brown </tbody> Above are values & we have another sheet of categories. In categories there are numbers like below <tbody> Red 17 White 18...

I have this extensive list some of it already have a full stop at the end of the phrase, I need to insert the (.) at the end of the cells that do not have full stop already. Any help is more than welcome. If possible with formulas would be very appreciated. Thanks in advance

i have an excel formula below that i need to add a column to after each day of the week,. How do i write/adjust the formula to give me what i need...