formular

My name is IMaadh, I’ve created an Excel sheet that functions as a searchable database. Currently, I can search for any single entry within the table, but I want to enhance it to search for details in two cells simultaneously. Example: Table headings: Staff Number, Username, Location...

Hey all, I have a problem and have NO idea how to solve it - it is about a dynamic sheet that should show a timeline (Calendar weeks) and quantities in that timeline. Attached is an sample workbook with all information -> 20230522_SAMLE_WORKBOOK.xlsx But here are additional information: B12 &...

Hi, I am creating a summary sheet book with hyperlink icon or hyperlink formula to the another workbook “datasheet“ however i found the below issues. 1. For the right click and create hyperlink, it is easy to do but when I save as the summary sheet workbook and the another workbook "datasheet"...

Hi All, I am trying to design a formular, I have a list of products with its descriptions. Also I developed a function called similarity which determine two cells similartity %. So Now I have a list of new products and old products list with its functions. Is it possible in B15 and B16 to use...

Hello, I have the following formular: =FIND("*",H12) This searches for the first * character in cell H12, and returns the character position of that *. And it works great! However, I have a condition where sometimes H12 doesnt contain any * characters, and has a hash (#) character instead...

when i run the macro i get Unable to set the formular array property of the range class Columns("B:B").Select Selection.Copy Columns("M:M").Select Selection.Insert Shift:=xlToRight Application.CutCopyMode = False Selection.Copy Columns("N:N").Select Selection.Insert...

Hello I have a spreadsheet with dates in collum E, P and S. The dates in Collumn E and P are Manually entered. The dates in Colums S are based on culumn E with the simple formular =E:E+91. Collumn E indicate when the different projects starts. Collumn P are delivered dates and Culum S are...

Hey Everybody! I hope you guys are having a great day! I am currently working on something and I am really stuck and was wondering whether anybody had an idea of how to solve this problem. So If you look in the spreadsheet which I have attached in column H you can see a long list of data...

Hello all, I am a novice and before writing this post I did try to see if this question had been answered previously. I have data in a date format in column "I" which I would like to be automatically entered in the neighbouring cells in column "J" but with 3 months added to the original date...

Hi Friends, I have five spreadsheets in which each spreadsheet contains 100 rows of text(instead of text I put a1, a2, a3 row names to easy construct formula but its kind of confusing to me). looking for a formula which can skip every: 1 row in sheet1 2 rows in sheet2 3 rows in sheet3 4 rows...

Hi <tbody> Apples Bananas Shopping 1 1 1 2 1 </tbody> Say i want to put a formula in the shopping column that will put a 1 in the shopping column if there is no figure in Apples and a figure in Bananas. I also want a want to leave it blank if there is any figures in Apples...

ok so do I need a formular or macro? (ps rather have a formular) if cell A1's value is populated from a Lookup formular I want a specific photo to appear next to it. ie: A1 = "dog" so photo "dog" is there, if A! = "cat" then photo 'cat' pops up if A1 = "bird" then "bird" appears. photos may...

Hi every one, Ive been glued to this forum for seval hours now, reading older posts, but Im going to admit defeat before my brain explodes!! OK so Im a novice with excel, but I dont want to be beaten! Also before answering, can you help me by just keeping it simple, and basing it on 100-20%...

ok im trying to create a sheet for my girlfriend. she has stomach problems depending on what she eats. ive made a sheet so she can put down everything she eats and give it a score out of five depending on how she feels the next day. the problem is i need to add all these scored cells up and...