Excel Forum
-
How to show an empty cell if =COUNTA counts 0? [Closed]
Hello, Iam having a bad time, I want to use =COUNTA but I hate the look of all the zeros when in all the empty rows that I didn't use yet,...
-
subtracting the date of admission to the current date [Closed]
GOod am, i just want to ask how will i create a formula as follows on the same excel, 1. subtracting the date of admission to the current date...
-
convert 12.01.2015 into words [Closed]
Hello, please convert 12.01.2015 into words System Configuration: System Configuration: Windows / Chrome 55.0.2883.87
-
macro to paste special values [Closed]
Hi All, Am new to macro, i have an excell file in which column A is having dates with formula....for example cell A1 is stored with 01/1/2017...
-
If cell contains a certain text, add the numbers of another cell [Solved/Closed]
Hello, I am trying to do my finances in an easier way, and would appreciate it if anyone can help me with the below question: B2=Supermarket ,...
-
stop duplicated with multiple cells [Closed]
Hello, I have a holiday home that I rent out and I am making a spreadsheet to control bookings, I have it set up so that the entry date and...
-
Need formula for comparing differences of two columns. [Solved/Closed]
Column A and B both contain numeric values. I want Excel to look at both and give me the numeric difference between the two in a new column C. I...
-
if cell contains a certain text, add the numbers of another cell [Closed]
B2=Supermarket , C2=30$ B3=Fuel, C3=20$ B4=Fuel, C4=50$ if Bs="Fuel", i want to add the numbers in the adjacents cells together. but only if...
-
Opening 602 spreadsheets with window 10 excel. help [Closed]
Hello, I have used 602 Office suite for several years and now I have 10 years of spread sheets that I cannot open with windows 10. Do I have to...
-
Transfer formulas only from one spreadsheet to another [Closed]
Hello, I want to transfer formulas only from one spreadsheet to another but I get all the data I even specify paste formulas
-
Stripping out some text form a larger string [Closed]
Hi All, I have very basic skills in excel - I'm trying to work through some data, and I have a long string of text - which has a common word...
-
need help for excel formula [Closed]
Hello, if cell contains text and date also for e.g 02-01-2017_Address Verified / 30/12/2016-Number busy / 28/12 Number busy. like this their no...
-
Copy ActiveChart properties to cell (from graphics) [Solved/Closed]
Hello, I hope someone could help me. Working with graphics in excel, I generate dispersion plots from some datas, later I add the trendline,...
-
Formula Help - IF FUNCTION [Closed]
Hello, I'm trying to create a formula which would give me the total amount sold. So for example I'm trying to get a formula which would say if...
-
link info [Closed]
how do I link text information from one worksheet to another?
-
desktop reminder with excel sheet and VBA formula need. please s [Closed]
desktop reminder with excel sheet and formula need please support.
-
Copying Conditional Formatting with Formulas Accross Rows [Solved/Closed]
Hello, I am trying to copy the color formatting along with the formulas across the entire row but the colors don't change based on the formula....
-
Multiple IF formula in one cell, date comparison [Solved/Closed]
Hello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close...
-
Text colour doesn't change and cell borders don't print [Closed]
I cannot change the text colour in a spreadsheet and the cell borders do not print out although they are there on screen. I have the CD for...
-
Why sum of some numbers is 0 [Closed]
Hello, I am trying to find the sum of some numbers in a column in a maxro book. I make the formula of sum and the sum appears 0. In fakt,...
-
Convert number to assigned names and joined with another names [Solved/Closed]
Hello, Please anyone can assist me on the below issue. that if I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.......
-
Excel VBA scripting - Changing a cell color based on contents [Closed]
My VBA is a bit rusty so hopefully I can get a little help. There is a report I need to create every week that I want to automate a bit. I...
-
Conditional Formatting Excel 2013 based on content in other cell [Closed]
Hello, I have a spreadsheet with columns that have targets and results next to each other. If the target is reached (=) or exceeded (>) I want...
-
Excel Sheets automatic updates [Solved/Closed]
Hello, I am trying to collect budget request from different departments and if all approvals fields are Approved, I want all data to be...
-
If Date [Closed]
Hello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close...
-
Macro for merging data from multiple sheets [Solved/Closed]
Hello, I want to copy data of 2nd columns from all the sheets to different columns of single excel sheet. Is there any macro code available for...
-
Display dates from multiple cells in one cell [Closed]
Hi, I want to combine dates from multiple cells into a single cell in the same row, with the result displayed in the format: dd/mmmm/yyyyy,...
-
a lot of names and dates [Closed]
Hello, I am trying to find out a formula to use. I have a lot of names and dates. and another tap has names with days worked. I am trying to...
-
how to convert Date into text. [Solved/Closed]
Hello, how to convert Date to words in excell in large for Tc use e.g 05/01/1992 To change five January,Ninteen Ninty Two System...
-
convert number to assigned names and joined with another names [Closed]
I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell A - i will enter 123 cell B - will have result of Biju, Daisy,...
-
Excel 2013 coping on row of a spread sheet to another [Closed]
I have a workbook with spread sheets wk End 1-15-2017, wk End 1-22-2017, wk End 1-29-2017 Looking for a way to have the row that is unfinished to...
-
Calculating rate based on date range [Closed]
I'm trying to figure out how to calculate a rate of payment based on two sets of date ranges: 3 days or less - $15 4 days or more -$10 How...
-
Insert New Excel Sheet [Closed]
Hello, I need the code which will create a new sheet in existing workbook if data are entered in a row. data generating should be in the format...
-
Using 1 Table to Apply Values to Subsequent Cells [Closed]
Hello, I usually search google for my excel questions, but this one is tricky! It may even be beyond the scope of Excel. In a nut shell, I'm...
-
Updating Master Sheet with most recent data [Closed]
Hello, I'm curious if anyone knows of a way to have a master sheet/summary sheet only update with the most recent data entered on a different...
-
How to create auto sheet in excel macro [Closed]
Hello, I need a excel Macro which contains separate sheets for each day in a month. By running the macro there should be auto sheets created in...
-
copy files from Google Spreadsheet to Excel [Closed]
Good Day partners How do I copy files from Google Spreadsheet to Excell, or How do I merger files from Google SPreadsheets
-
Copy row and it's contents based on value in X cell. [Closed]
Hi everyone, this is my first post so I hope I'll explain myself clearly! I have a spreadsheet with the following content: (Column I (in...
-
IF formula needed [Closed]
Hello, I need a formula that IF there is any data/text in the cell it will EQUAL another cell, BUT... I want the cell with the formula to...
-
Statement that returns pass, fail, "" [Closed]
Hello, Wanting to test row of numbers to a certain number and return pass, fail, or blank. =IF(AND(X7
-
Adding 2 cells to another sheet under If condition [Closed]
Hello, if i have 2 sheets and i want to add 2 cells of the 1st sheet to the other one -- only if another 3rd cells has the text "Done" what...
-
Excel Formula [Closed]
Hello sir, . But its can't working why i dont know! Please find my attachedments. Regards, Bicky Das, bickydas00@gmail.com
-
Function button: Unhide cells between values and hide all other [Solved/Closed]
Hello! I am new to macros and this one is proving to be a bit of a challenge for me. I am building a template that contains several...
-
Macro for adding pictures according to cell value [Closed]
Hi! I have this visual sheet (pic attached), and I would like to create a macro that would insert a picture from a folder on my computer in the...
-
Cell content move with VBA code [Closed]
I have a workbook that we create service tickets from. The main sheet is used to enter information about the job. When complete I have a button...
-
How do you have multiple out comes for the same if condition in [Closed]
Hello, I have a condition in my file such that =IF(C5=C4,D3+1,D5=1 ->>>> trying to add this andD4= D3+1) Basically this what I want to happen ...
-
Conditional formatting based on another cell? [Closed]
Hi everyone! I'm trying to finish my financial sheet to work out where I am for this year. I need it so that when I type in the word "yes", It...
-
Formula 1,2,3 division [Closed]
Hello, sir Plz notice the formula =if(cell address >55%,"1st",if(cell address >50%,"2nd",if(cell address >45%,"3rd","Fall"))) is the correct...
-
Automatically transfer data from one sheet to another [Solved/Closed]
Hello, I have a workbook with several worksheets (Master, Pending, Lost, Sold, and Bidding). I would like to be able to have certain line items...
-
Quick Access Tool Bar [Closed]
Hi Everyone, I'm new to this forum. Thanks for the help and advise in advance. I'm a beginner to VBA. I have created a custom Quick Access Tool...