Hi, Brand Spanking new here! The problem with my code is my needing to use a For Next Loop Variable to specify the searching range within a VBA COUNTIF...
Dim x As Integer; Dim y As Integer; Dim FND As String;x = 0; y = 0; 'Put on 1 line here just so code all shows.
For x = 1 To 10
FND = Sheets("Sheet2").Cells(x, 3)
For y = 1 To 10
Sheets("Sheet2").Cells(x, 4) = "=COUNTIF('Sheet1'!y:y, """ & FND & """)"
Next y;
Next x;'So it's the y:y in the COUNTIF that beenabout 11 hours straight now! My intention is for it to be a range of 1:1 then with next y it to be 2:2 and so on.

Hi there,

I have created a large spreadsheet and I was wondering if it was possible to create a formula where the value of a cell updates automatically based on the date.

To make it easier to understand, the spreadsheet calculates a score for fighters in MMA and I want to deduct a certain number for every month since their last fight. I.e an inactivity score.

So I have a date next to each fighter and I want a cell to automatically update the score based on the date.

Looking for a way to reposition cells in one column based on another. A screenshot of the requirement is attached for reference.
Regards

Hi All

Any help greatly appreciated. I'm new to the forum and excel so please forgive me if I don't explain things very well.

I have created an excel spreadsheet for recording my monthly expenses for working with different clients. Called Sheet 1. There is a table in Sheet which summaries my expenses. Within the table, there are multiple rows - each row represents an expense item which is assigned to a Client and each Client may appear several times in the table as follows:

Client 1, Travel, £22.00
Client 2, Subsistence, £18.11
Client 1, Meeting, 33.00
Client 2, Travel, 94.13

Hello, I want an excel program that will extract the contents (values of results) from the sheet (HND 1 FIRST) and display it as a sample of the first student (ABIODUN RACHAEL) attached.
(1) Out of the labels (Name, Matric No, Department, Programme, Session), the matric no will be the variable to use to get the name and the corresponding student.
(2) The student results will automatically extracted into the new page for printing like the sample attached.
(3) The Course Codes, Course Units and Course Titles are in the attached document as (COURSE)

Hi,

I am trying to figure out how to create a formula that will give me the difference between the Awarded Green Sheet number and the Not Awarded Green Sheet Number for the subcontractors with the same trade and same project. Attached is an image of what I am looking for.

Any help is appreciated.

Thank you,
Allison Buffy

hey can someone help me?
I am using the excel Any year one month calendar and everytime I add things in one month it appear/repeats on every month. how can I keep this from happening and keep what I put in January to stay only in January and so on?

please help
thank you

Hi,

I have tried using Index and match to get out put. Help required for column validation/Match from Worksheet Input ranges (A:A,B:B & $C$2 to $G$2), result required is in Output worksheet column D for same matches for ranges given from input worksheet.

Attached Excel, Input and Result expected in Output.

Thanks,
Naveen.

Hi All, appreciate all help provided, Simply yet challenging for me.

I need to add the cell values in a range which is defined by A1 value.

A1 A2 A3 A4 A5 A6 A7 A8

3 * $1 $2 $3 $4 $5 $6

So A1= number of days away
A2=formula
A3= Day 1 price
A4= Day 2 price
A5= Day 3 Price.

Simply put, I need to add the next 3 cell to the right of the *. I.E I want the answer to be $6 for 3 days. and for 5 days $21. Simple yet confusing me. I cant work out which formula to use and how to get A1 as a reference for the range length.

Thankyou .

Wondering if anyone can help with this. I have a table with athletics events down column A and Club names across the top. Names will be filled in against events and clubs. I then wish to pull names into from the table to the actual event once run. However clubs run under one of two numbers eg 12 & 112. I have tried the formula below which isn't working which looks for the event in Col A and then tries to MATCH either of the club numbers to give the corresponding column number. It works if the correct number is in the first array but not the second. Image attached & File attached.

I have a couple of questions regarding two formulas in one cell and getting #value when one of the formulas cells are empty.

The attached file shows the questions I have.

Thanks for the help!

Hello,

I just started a job for a company. We license a curriculum and track the number of students in classes using that curriculum. Someone created this big, clunking, hard to navigate document that basically has actual information for all classes and then "predicts" how those classes will mature. You can see a pic of this in the attached images "LogDocSnip".

In that image, the first 5 columns are real data: School name, Unit (within the curriculum), Number of students, Start date of unit, and how many new classroom materials in this current month(CM).

I want to retrieve the value from column 'Particulars' on 'Sheet3' and its correspondent values from column 'Bill No.' and 'Amount' if the value from 'Particulars' column on 'Sheet3' is equal to the value from 'Particulars' column on 'Sheet2' and its correspondent value from column 'Quarter 1' on 'Sheet2' is greater than 0.

I want to do this with built-in formulas only if it could be done that way.

I need help and can't figure out how to do a simple formula. I would like a formula that looks at 2 cells, determines if there's any text in them and then chose the text if one is filled in. I hope that makes since, I've tried to put an example below.

I'm using Excel mac:2011, and i'm operating on MacOS High Sierra. and I was trying to create a user-form for an already existing data, designed the form, but I am having a problem, or rather I'm stuck on the combo box drop down add items. For “rank " Combo box, I wanted to add number 1-50, “State” combo box i wanted to Add all the States in the USA but abbreviated, " number of full-time employees, " i wanted to add " numbers and N/A” as a drop down and last combo box of " Year Est. " I wanted to add years ranging from 2018-1900.

I have a formula
=IF(G4=0,E4,C4*(1-G4))
It works fine. It's pulling from either column G or E.
However if no data is entered in either column, then I'd like it to pull from column C.

When I try to do this, it says too many arguments.

I thought of something like...
=IF(G4=0,E4,C4*(1-G4),IF(E4=0,C4

Then I'm lost.

Any ideas? Thanks!

Hi, I'm a school teacher and I head up an ISR Department and I am attempting to do a Spreadsheet that keeps track of several things, such as; Student Name, Time Served In Detention, Infraction, etc... I should state that my wife found a generic spreadsheet that "she" was able to change things around a little bit to fit what I was looking for... BUT here's my question:

Hi, I've been using excel for a while and I just started studying the more advanced features of excel and came across VBAs. I was wondering when the best time to use VBAs are and what is a good way to get a better understanding of the different code used.

I am looking for a way to fill a number of cells in a row/column based on a particular cell's value. So, if a cells value is say 7 or 3, then 7 cells or 3 cells must be be filled with a particular color.

Thanks in advance

Hello

I want to know , can we lock cells in excel sheet after we paste data on it ? that make cells uneditable after paste.

I mean , to make the cell locked after we paste data
then the data on the cell can not be changed
is there any way to do that?

I am working on a project where I compare values from one worksheet to another. When I look at the cell (for example A1), the value in the cell shows 8.999. When I look at the cell (for example A1), in the second worksheet, it also shows 8.999. My code highlights the cell if there is no match. The code highlights these cells as not matching. When I look at the top of the ribbon, the cell shows not as 8.999 in the first worksheet, but 8.999888888888. How can I make these two cells as equal, so the cells will not show highlighted as not matching. Hope this doesn't sound confusing.

Ok so I am not an expert at excel, but I know basics on how to pull from different sheets.
That being said my issue is:
I have Sheet 1 (Builder List) that contains all the builders that I work with, you will notice there is an empty column that is labeled "Total YTD Price". I want to transfer data from Sheet 2(Project Tracker)Column F that is labeled "Total Cost"

What I've done is created a question by question quiz that should tell you if you're correct and then automatically go to the next randomly generated question.

Find attached data on a1 , going at 34172 words

Expected results on B and C

Looking for words with same consonants but different vowel combination
It should also be able to pull words with two vowels , 5 same consonants ,
example BANTERS BARNETS BARTONS BRETONS BRISANT BRUNETS BUNTERS BURNETS BURSTEN BURTONS

The macro should also be able to handle 8 letter words , attached is 7 letter word length

I am currently working on the withdrawal form.

a. I have created auto deduction from the balance.
Here is my formula for auto deduction for your review: =IFERROR((SUM(VLOOKUP(C7,UHSE!$B:$E,4,FALSE)-G7)+I7),"")
Please kindly educate me if my formula has an error.

b. But i found if i have input duplicate part number in the same form, my balance cannot show an updated balance.
Please educate me what formula can work for my problem.

Hi Everyone!

I have a task which needs to be done in excel. I have to calculate collection discount as per company policy which is if payment is received within 30 days customer is entitled to get 2% discount.
I have invoice wise sales data and receipts data in excel. Problem is we don't receive payments invoice wise rather we receive a lumpsum amount for example customer pays us 1000000 for the month against 5 invoices of random amount. I have to allocate this payment on fifo basis.
Is there anybody who could help me in this matter?

I will be really grateful to you.

Background:

Insurance company that processes claims from clients. Once a contract is entered, the client is assigned a unique reference number and the date of contract entry is recorded.

Issue:
If I have two excel sheets with data;

1. Sheet 1 has claims made by clients showing:
- Dates of the claims
- Unique client reference number.

2. Sheet two is a record of existing clients showing:
-Unique reference numbers
-Dates on which contracts were entered

Note:
The claim date may not be before the contract entry date.

How do I check that:

I have a spreadsheet that is only one page in length. I will be sending this to my clients. I want the whole file to be only one page, not endless rows and columns of blank space. Does anyone know how to restrict the size of an excel file to one page? I have a Mac and a recent version of Excel. Thanks.

I have list of employees in one column “A”. And their year ratings or the previous three years in the columns “B, C, and D”. Their new rating for this year will be in the column “E”. I want to do a formula that makes Excel give me if the employee is meeting a giving criteria. i.e. any employee with two rating “S” is meeting the criteria by giving me True or Yes in the column “F”. Or instead make a highlight.

So, is there a way to achieve what I am looking for by Excel?

Yours faithfully,

I have created a Gantt chart in Excel and want to label the data points for Duration with the Activity Name. This is easy in Excel 2013 and 2016 because the Format Data Label Options include the option “Value from Cells”.