## Find/search formula within cell

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 …

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 …

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 …

I have a problem with my VBA. I want to send Emails to various people attaching individualized documents and setting parts of the Email body as text from a …

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) …

Hello, I am attempting to build a formula where column M would fill based on the imput in column L and change based on a value entered in Column K. I …

Hi, I have a spreadsheet of data. Mine has 275 rows. Another team gives me their information which I paste onto the bottom (they have 750 rows). I pasted this …

I have a cell with a simple formula and I would like to round the result in the same formula in the same result cell. Example: =SUM(K16*1.03) with the …

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 Expert,It’s really a pain when we need to breakdown the long formulas in excel into vba. Been trying to do below but I really don’t understand …

Hello, I am looking to create a report that pulls data from specific section on another report. The report i want to make will have a new days worth of …

Well….this is my excel and i want these results : My criteria is ” If you find same value from A Column then get the data beside …

Dears, I have a large number of data I want to distribute in a specific way Let me give you an example # The data consists of several columns with an …

Hello, I would like a formula or format condition to have in cell A1 the number 1. Then when I type over number 1 again to appear number 2 (and in the formula …

ABCD 563 443 CLOSED 563 443 #VALUE! ABCD 563 443 CLOSED …

Respected, My scenario is as follows: Lets say I have 5 criteria mentioned in columns ( C,D,E,F,G) I have site names provided in column A I have product ID …

I am downloading college basketball rpi rankings that change nightly. I am assigning the ranking of each school to a cell on an earlier page. Example: If the …

I am trying to find a way which can calulate number of hours between two times. Not sure if there is a way to do it it in excel? I have one column with time ( …

I have a database of annual salary costs based on country and post level on one exel tab. There are 2700 rows (based on 18 posts levels across 190 countries). …

I apologise I am starting to learn VBA – very slowly! My proble revolves around two worksheets: “Front Page” and …

Hi All, I need to be able to search data were we have 1 client with multiple expiry dates of policies. We need to pull the data of the oldest …

Hello, I’ve created a timeline tool where the left side of the excel sheet is the internal inputs timeline and from there it spits out a summarized …

Hello, I’ve created a timeline tool where the left side of the excel sheet is the internal inputs timeline and from there it spits out a summarized …

Here is what i am trying to do….is there one formula that would work? In J2, I want to sum L2:R2 where the value of any text is = to ‘1’ …

I have a lot of formulas, which means I want to know what they said and for what it is done. like :- =LOOKUP(Answerkey[[#This …

QNTY PIECE MARK SIZE DESCRIPTION LENGTH LENGTH TOTAL LENGTH (FT) FT IN FT 1 1C1 W8X21 COLUMN 4 4.375 4.36 4.36 1 1C2 W8X21 COLUMN 4 4.375 4.36 4.36 5 …

I have a situation where i am supposed to take a count of only unique value from the sheet (excluding one value repeating in different months) and i am …

I have cells that have an iteam description in them depededing what the are I have highlighted them. for exmaple all iteam that are plastic are …

Hi, I want to make the information in some columns (but not all) displaying in rows, please see below an example. This is what I have: …

How do you take a formula in a column from page 2 and have it copy automatically to a column on page 1 By:

I am trying to paste in something from another sheet. I went to that sheet, copied the cells. Went back to the original sheet and, to make a row for the cells, …

I’m tryint to fiure out a formula for a spreadsheet. I need the formula to add the number purchased in e2 to be multiplied to the $ value in …

Fill the “Needs contacting?” column with YES or NO taking into consideration that the customer needs to be PAST DUE (due date <today) and NOT be …

I WANT TO GENERATE RECEIPT FOR HOME[RS.100] WHICH CONTAIN LAND[RS.60] AND CONSTRUCTION COST [RS.40]. WHEN I RECEIVE RS. BELOW 60 ,MENTION”LAND”,AND …

I HAVE A EXCEL SHEET LIKE THIS GIVEN BELOW …

Hi, I am working on a project that requires me to merge two datas in one. I am currently inserting cells then copy pasting the data, which requires a …

I have 2 worksheets. One is just a templete of what i want to copy over from the other worksheet. The other worksheet has over 900 rows. i want to transfer …

I am using Excel 2010 and could you please help me with the following request. Suppose A1 to E1 each contains as follows: A1 CAT …

I need a VBA sub that will use the title of a sheet to find the matching text on another sheet and use that text as reference to retrieve other data in the …

I have a table of Occupancy ratio and prices for a hotel Column A Column B Occupancy Price …

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.