The discussions
Conditional formatting a cell if a certain word is met
SolvedHi I am trying to conditionally format cell B3 if the criteria in cell C3 = NAT I am able to do it if it was a number but not if its a word, If the ...
If formula showing date
SolvedHi all, I created a spreadsheet that has a date in and a date out columns, the dormula I use on the date column is: =if(d2,TODAY(),""). Formula is in ...
Excel vba: application.filesearch error
SolvedHello everyone, I encountered error "Object doesn't support this action." when the program the line "With Application.FileSearch". Here is my codes...
Conditional formatting
SolvedHello, Does anyone know if you can set conditional formatting to highlight an entire row if the date in a specific cell is less than a week from t...
If data matches in one column, check 2nd column matches
SolvedI've been trying to figure this out for days, I'm sure it's possible but can't get it to work. I have a set of data - in one column there are refer...
Help to convert a date to julian date fromat yyyyddd in excel
Solvedhi, i have thousands of dates in format dd-mm-yy that needs to be converted to julian date format yyyyddd. dates that needs to be converted are fro...
Is there a way to call out multiple values in single cell?
SolvedHello everyone, this is tricky and im not sure if i have missed something or if this is even possible, if it is it would be a huge help. I am limited ...
Due date reminder in excel 07
SolvedHello, dear all. I have a "credit list" worksheet having the details like. 1) date 2) invoice number 3) name of beneficiary 4) total amount 5)paid c...
Ms excel, lookup word from a cell
SolvedA B C 1 C287198 MARIQ BLDG MATERIAL TRDG C287785 C287785 2 C2...
Excel formula
SolvedI have a blank excel invoice that I want to be able to type the Item number on it and have it populate the vital information on it like the item name,...
Need help please: excel click timer to time each work/task
SolvedHi Excel Pros, This is my first time to join the excel forums and have seen how helpful you guys are here. I need to come up with a visual basic...
Error ox800ccc79
SolvedHello, This is driving me nuts... I can recieve mail but not send please help Outlook Express Configuration: Windows XP / Internet Exp...
Copy multiple charts to multiple worksheets
SolvedHi I have a challenge for which I cannot correctly conceptualize a workable solution so I am hoping someone here can share their thoughts on it. ...
Excel macro: rename all worksheets
SolvedSo, I'm trying to figure out a way to rename all the worksheets in a workbook. the first worksheet would be "1" (without the quotation marks) and c...
Excel macro help, hiding columns
SolvedSo I'm trying to figure out an Excel macro that would hide row A-K on every worksheet in a workbook. Thanks for any help
Need help to create an excel macro (combine columns)
SolvedHello, Inputs Col A and Col B ( all data ranges are variable), need out put in C Col. (MACRO), I not good at vba/e , kindly help. Col A ...
Add two type mix font in one cell in excel 2003
Solvedhallo i have a excel 2003 userform with textbox . I have problem in my data base . I have 2 type font in my data like DevLys 010 and arial. I want to...
Recurring date formula
SolvedHi All I have the following formula in my worksheet =IF($AA$2=2,B8+28,IF($AA$2=1,B8+7,IF($AA$2=3,EDATE(B8,1),IF($AA$2=7,EDATE(B8,12),IF($AA$2=4,...
Cant format date in excell
SolvedHi, When I enter the dates as number with out forward slashes, and format them by right clicking on format cells and choosing date the date appear...
Lookup same entry a1 in 2 worksheet & return b1 from 2nd w/sheet
SolvedHi, I have 2 worksheets. "Master" = Sheet 1 "Status" = Sheet 2 In "Master" Worksheet there are 3 columns, A1-User ID, B1-Username, C1-Status...
Macro range
SolvedHello, I am somewhat inexperienced in the world of macros in excel. I have a looping macro that runs from the bottom and i want it to stop at ...
I am just learning the basics
SolvedHello All, I am new to this community. I have just started learning Excel and am having a problem with a formula. the community here from what I have...
Create a macro
SolvedHello, Please help me. I am new at macros, and I need to create a macro that will automatically total a column as below: # Name ...
Need help with an if function
SolvedSo, I am trying to get this formula to work. The situation is that one of our items have changed names. In the spreadsheet, I am trying to get a f...
Excel date problem
SolvedHi, How can I change the date format from a format such as 22042013 - (this is not a text format). One formula I have been given is: =IF(LEN...
Any part of string in cell matches part of string in another
SolvedFirst post after hours of fruitless googling :-) Working in Excel 2010.. I have merged two data sets and where there are instances of exact dupl...
Conditional formatting can't caputure text...need vb code please
SolvedHello, I understand i can't use c formatting to insert text and therefore am looking for a piece of code that will perform the following. Consi...
Conditional formatting based on changing dates
SolvedI am trying to keep on top of dates that are changed weekly based on last weeks dates, but i need to highlight the changed cells only. Example: ...
Find and compare calues in two columns
SolvedHi i need to look for values (strings) in column A and see if exist in column B. if exist return the line number. (tried vlookup but i get only ...
Help with cell programming!
SolvedHi everyone. this is my first time here, and in desperate need of help from some Excel Genie to make my wish come true! Ok, here is my "urgent" pro...
Conditional formatting in excel2010
SolvedI wish to have the following CF in more than three colours. I have placed the following in Data List L1,L2,L3,L4,L5,L6,M7,M8,M9,M10,M11,H12,H1...
Help needed in using marcos
SolvedHi, I need to write a marco that is able to compare the specific column in 2 different worksheets within the same workbook. (i.e Names of staffs) ...
Conditional formatting in excel - off of a range of cells
SolvedHi I've never used these forums before but this issue has been bugging me for some time now.... so i thought i would leave it to the experts.... I...
Macro
Solved/ClosedI want to write a macro from the start, I have date of employee name and their attendance on a workbook and on the other workbook I have a calendar. N...
Excel help on if formula
SolvedI want to say IF cell L27 equals the word 'low' then do sum of cell x * cell y, if cell L27 equals the work "expected" then do Sum of Cell a * b and i...
Combining two separate macros into one
Solved/ClosedHello, I currently am using these two separate macros independently but would like to combine them into one with the archive one being first. I'm...
Date formatting in dd/mm/yyyy
Solved/ClosedHello, I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have i...
Macro to search/replace text from another column
SolvedHello, I didn't realize I was being rude on my previous post, that wasn't my intention. I tend to have a "too the point" personality sometimes, and...
Won't save passwords / usernames
Solved/ClosedHello, Computer won't save passwords / usernames, even when I ask it to and I have went into tools and everything was set as suppose to.
Urgent ansin excel
Solveda table caring 4 rows, first row is Name, second is address, 3rd row is date, and forth row is house name. how i arrange this in excel in date wise...
Popup reminder based on date and additional celll values
SolvedHi, I am new to this site and have seen a lot of great information and helpful tips here. I have been trying to figure this out for a very long tim...
Hide rows with zero value in multiple sheets
SolvedPlease help me in making a macro in the Excelsheet that: I can hide the entire rows if a cell value or (range of values) has a zero value in multiple...
Conditional formating
SolvedI have a spreadsheet with Excel 2013 that has text drop down lists. I want to use conditional formatting to highlight with a different cell color, dep...
Convert a date field in excel to day of week
Solved/ClosedHello, I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the week so...
Some help needed about if function with dates
SolvedHello, i m making a sheet with this function =IF(H1
Creating pdf from selected cell range
SolvedDear all, greetings. firstly , I would like to thank those who have helped me to get below code (to create pdf file for selected cell range) whic...
Microsoft office
Solvedgood day ! i would like to ask if how can i activate my microsoft office even though i dont have any activation code.. thank you God bless
Trying to write a code to insert a blank row above a cell value
SolvedI am trying to write a code that will auto insert a blank row above a certain cell value ie: existing: Column G 5 10 20 22 999 2 22 55...
