Windows Support Forum

Can I set explorer columns for data directory within music library

Q: Can I set explorer columns for data directory within music library

As an example, The Itunes directory is in My Music. My Music is in a Music library, so the file details in explorer include album, #, etc. Within Itunes is the Apps directory and other data where "album name" doesn't make sense. I want it to display as a non-music directory. There doesn't seem to be any way to set the default columns displayed in a directory within a Music Library without changing how all the directories are displayed. Nor does there seem to be a way to remove a Music Library sub-directory from being considered as a Music Library member.

Relevancy 100%
Preferred Solution: Can I set explorer columns for data directory within music library

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link (This link will automatically start a download of Reimage that you can save to your computer.)

A: Can I set explorer columns for data directory within music library

Hello EasilyConfused, and welcome to Seven Forums.

From within the Music library, you can change, add, and remove any columns you like.Windows Explorer Columns - Add or Remove
The tutorial below can help show you how to remove folders that you no longer want to be included in the say Music library.Library - Remove a Included Folder
Hope this helps,
Relevancy 72.67%

I am trying to delete some music in the library but explorer just freezes up and takes up 90% of my cpu while doing this

the green bar never finishes

and the files never get deleted
after I end explorer from the task manager, dllhost.exe takes up 25% of my cpu also
even just opening the music library takes up a lot of cpu and I was wondering what this was and how can I delete these files
Relevancy 66.65%

I started out with the two previous posts about macros (post 1, post 2) that move rows into columns, but I'm having a little trouble getting it to work for what I need. First, I'm trying to do a data merge into Word, but in order to get the data merge to work/look the way I want it to, I need the XLS data to be in columns.

I'm attaching an example file that has one worksheet of the sample data (though my "real" data has about 300 rows) and the other worksheet is an example of the outcome I need.

Is there anyway I can do what I need? Exporting into another file or another worksheet within this file would be fine.

Thanks in advance.

A:XLS Macro to move data to columns, delete empty rows, delete duplicate columns
Relevancy 64.93%

Not being that experienced, I'm a little confused w/ the way the Library sorts CDs into genres vs the way I could sort the Music Folders. They don't seem to relate. For example, the Library lists an album under "Rock" that I would like to move to another genre but I cannot figure a way to do this. On the other hand, I know I could play around w/ the folders so that this particular CD is in the right place. However, I'm not sure that if I take the time to organize my Music folders whether this will have any impact on how the Library sorts them.
If you can shed some light on this I'd sure appreciate it.
Thanks, Nick.

A:Solved: Windows media music library vs music folders

Mp3 music files have tags that are kept inside the files themselves. The most common ones are Artist, Album, Track Title, Track Number, Release Year and Genre. When you put a file into the WMP library, the tags are read and stored, along with the file location.

So the tag data is what shows up in the WMP library and you can sort on various fields depending on which version you have. But the files can be put anywhere and named anyway you like. Most people use a certain naming convention like Artist-TrackNumber-Title.

If you want to sort the folders by genre you could do that, but you'll have to do it manually. You can do some manipulating of folders and filenames with tag editors. If you want to give that a try get Mp3Tag.
Relevancy 63.21%

I have data that repeats hundreds of times. I am trying to put each string of data on 1 line.

f-name(A2) initial(B2) l-name(C2) ID#(D2) DOB(E2) Street(F2) company(G2)
City(F3) company#(G3)
Home Phone(F5)
Work Phone(F6)

After the data is moved to one line I would like to delete the lines that previously housed the information. The company# can be deleted. I have never worked with macros. I would appreciate any help given.

A:Solved: move data from rows and columns to other rows and columns

Relevancy 63.21%

Hi I recently migrated to Windows My music collection stumbled along the way and I had to re-fetch artwork for a few albums in WMP I also Xbox album No art library or in music Music! set it up in iTunes My default app for MP s is WMP As you can see below artwork only appears when in the folder view which somewhat defeats the purpose of libraries in the first place I'd prefer to No album art in music library or Xbox Music! sort them by artist with album art displayed without a folder as it should and as it did in Windows Art appears in folder view but not artist or album view On a related note I recently added many new MP s to my collection When I opened Xbox Music for the first time afterwards it seemed to be downloading art to add it to my older albums all of which have art Then the process was somehow interrupted I believe I closed the app Then when I opened it again none of them had art I would very much appreciate your help

A:No album art in music library or Xbox Music!

Help please?
Relevancy 61.49%

Hello. I'm not sure where to post this question.
I'm feeling kind of silly to ask this question, but after weeks of trying myself, I am frustrated...
I am so confused about Libraries and my Directory.
(If that is what it's called)
My desktop is not where it used to be and my downloads too. For some reason, it is in documents and pictures etc...when I try and drag it out and put it where it used to be, it won't go there. It wants to link to favorites. To access Desktop now I have to go into my pictures and it's making me nuts for 2 weeks now. I don't know what I did.
How do I get it back to how it was originally -between Favorites and Libraries???
Can someone tell me how to fix this mess please.


Quote: Originally Posted by Elljay

Hello. I'm not sure where to post this question.
I'm feeling kind of silly to ask this question, but after weeks of trying myself, I am frustrated...
I am rather new to PC land and I am so confused about Libraries and my Directory.
(If that is what it's called)
My desktop is not where it used to be and my downloads too. For some reason, it is in documents and pictures etc...when I try and drag it out and put it where it used to be, it won't go there. It wants to link to favorites. To access Desktop now I have to go into my pictures and it's making me nuts for 2 weeks now. I don't know what I did.
How do I get it back to how it was originally -between Favorites and Libraries???
Can someone tell me how to fix this mess please.

Please post screenshot
Relevancy 60.2%

I would like to permanently change the columns in my music folder to add bit rate and length. I have many folders. I'd like to do it all at once if possible. All my music is on an external drive so I don't know if they will remain permanently when I remove drive but is this even possible?

This has bugged me for some time so nay help is greatly appreciated. Thanks!

Relevancy 60.2%

Hi all,

Basically I'm wondering if there is some way to modify the order of the columns in newly created folders optimized for music. The default order is:
Name > # > Title > Contributing Artists > Album.

I'd prefer it if was:
# > Title > Name > Contributing Artists > Album

I know this can be done on an manual and therefore small scale, but I have a large music library and would like the files within the music folder automatically sorted by track number with that column preference. Like maybe if there was a way to apply the column preference to the My Music folder and all subfolders.

A:Solved: Windows 7 Music folder columns

Just click and hold the column name and drag it to where you want it.
Relevancy 60.2%

Before Windows XP My Documents was situated in the WINDOWS Desktop quot folder quot In Windows XP My Documents was no longer inside the WINDOWS Desktop quot folder quot even though it could be Folder in Library is the In My which situated directory shown on the Desktop It was relocated to be inside Documents amp Settings user name keyed In which directory is the My Library Folder situated in in and it took me a while to figure where it was located back then Now in Windows My Documents has once again been relocated to be inside Users user name keyed in It can still be shown on the desktop and can also be shown in My Library My question isn't so much so about the My Documents folder but rather the My Libraries folder Without the quot up to higher-level directory quot button which was available in Windows XP it's a rather difficult task to find the destination folder in which the My Libraries folder resides in Does anyone know where it is located in On a sidenote does anyone know how I can enable the quot up to higher-level directory quot button which was available in Windows XP

A:In which directory is the My Library Folder situated in

right click on documents under libraries and choose properties. U wil find the location.

AFA up one dir button, I am not sure.
Relevancy 60.2%

I would like to add a Network Directory to Directory Network a a Library to Adding a Library I've come across this link although I couldn't understand the following Quote Create a local Adding a Network Directory to a Library folder in the C Users username directory This can be named anything you want so long as it is a valid directory name Add that folder into the library Open the library from the menu bar then click on the Includes locations link at the top Click the Add button on the right side and select the folder you just created Delete the local folder that you created DO NOT remove it from the library I first create a local folder in Users username then I add a folder library and I click on includes when I click the Add button the indexing option occurs I get thrown off track at the last set of instructions which are to delete the local folder that I've created I can't get to that stage because the networked folder needs to be indexed and the point of this technique is to not have to index the drive On the same page there is this program it appears it wipes out your previous libraries which you've created which is why I'm skeptical to use it I'm hoping someone can help me get one or the other to work or has another solution to this

A:Adding a Network Directory to a Library


Have a look at this tutorial

Hope this helps
Relevancy 58.05%

Alright so I have 2 workbooks lets say "workbooka" and "workbookb" they both contain the same column header "asset #". Workbooka has a list with no duplicates and is listed as column D. While Workbookb has a couple duplicates and is in column F. I wanted to be able to pull the information from workbookb into workbooka for only the "asset #" that match. Because of the duplicates however I have been running into a problem. Looking for input that does not involve a macros or add-in.

Thank you
Relevancy 58.05%

Hi,i found this question and seems near to my problem, but I totally dont know how to revise the code."Excel: Moving Column Data Into New Rows??"I have this data:UniqueID Company 1FullName 1Designation 1CountryCode 1Phone 1Email 2FullName 2Designation 2CountryCode 2Phone 2EmailR123456 Company1 Chris Reeves +65 90221111 [email protected] R234567 Company2 Sam Lim Sole Proprietor +65 9851234 [email protected] Samboy Lim Account +65 94890987 [email protected] Company3 Jose Accounts Department +65 67672345 [email protected] and I need the above data to be like this:UniqueID Company 1FullName 1Designation 1CountryCode 1Phone 1EmailR123456 Company1 Chris Reeves 65 90221111 [email protected] Company2 Sam Lim Sole Proprietor 65 9851234 [email protected] Company2 Samboy Lim Account 65 94890987 [email protected] Company3 Jose Accounts Department 65 67672345 [email protected] help.Thanksedited by moderator: Mask email addresses

A:Moving columns data into new row

I have edited your post to mask anything that looks like an valid email address. We do not want this forum to become a place where email addresses can be harvested. Once the bad guys start hanging around it's really hard to get rid of them.I can not determine the layout of your input or output data.Please click on the following line and read the instructions on how to post example data in this forum.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Relevancy 57.62%

Just a general question, In music library upper right corner it says folder with a drop down arrow and under the drop down are choices of album,artist,song,genre,rating when clicking on one of those nothing happends. Also when sharing my music alot of my songs are locked. I've tried select all/ share and tried doing them individually, neither work. Any ideas?
Relevancy 57.62%

Is it possible to fetch some lines of data from a group of web pages and paste in to Excel?Pls view the image for required excel columns.

urls are,
Stock Share Price dlf ltd | Get Quote dlf | BSE
Stock Share Price dlf ltd | Get Quote dlf | BSE
Stock Share Price jaiprakash associates ltd | Get Quote jaipra | BSE
up to 100 urls in a text file.

A:Web site data to excel columns

When you right click on the webpage and select "View source" from the context menu - do you see the info of interest; I don't. If the info were there, you could use InetGet. They know the value of the info being presented and they probably want to discourage automated data mining.

See if there is a mobile version of the webpage.
Relevancy 57.62%

Here is a sample of the table that I am working with:

Year Warehouse Item# Period1 Period2 Period3 Period4 etc....

There are many more columns but my issue is that if there is a 0 or blanks for all columns from period 1 to period 12 then don't show that row. How do I get this to happen with a query?

A:Access - hide row if many columns contain same data

In the first Criteria row for each period column enter
Relevancy 57.62%

Hello I have a really big problem in excel that I don t know how to do it In my workbook I have imported columns from txt files They are located in Z AA AB and AC Z amp AA contain the first and last name This can t contain any numbers AB amp AC contain the arrival departure hours This can data search same get two and columns VBA time t contain any words The list of names is made as the folowing the unique names always start from the top the dupplicated names always start after the unique list There can t be more than two instances of the same name and the list is contiguous Based on that I need to find only the dupplicated names that have one arrival and one departure hour in cells AB and AC So the first matched name should have AC blank and the dupplicate will have AB blank I will concatenate the names if it s easier to do the macro but I d rather not because the workbook itself is packed with loads of formulas and it s really making it difficult to calculate An example has been attached containg the VBA search two columns same time and get data expected result The workbook has sheets and they all use the same reference Z AA AB and AC from row and down Thank you for reading and for your intent to help I appreaciated Alex nbsp

Relevancy 57.62%

I ve been at this for what seems forever so any help would be greatly appreciated I want to compare data from one sheet to another and for any exceptions non matches I want it to copy and paste the entire row into a rd sheet I ve searched and found various codes about comparing columns but my need seems to be a little more columns VBA Compare data Solved: complex I want it to compare columns on sheet columns A amp B against columns on sheet columns C amp D and it does not what row they are in I also would like the sheet name to be included in the results I ve Solved: VBA Compare data columns attached a sample book with the data Sheet shows what data should generate from this code These would be the results because the names both first and last Solved: VBA Compare data columns do not appear on both sheets I dont have a lot of experience with code so any help would be great Thank you nbsp

Relevancy 57.62%

I'm trying to find a way to delete some data from a column, say column A. The numbers to be deleted are in another column, column B. Is there a way to have excel remove from column A, those numbers that appear in column B? It would require some way to compare, but I can't figure out if excel has this capability. If the columns were small, we could do this manually, but the data set is huge, with several thousand numbers.

Thanks for any help.

Relevancy 57.62%

Hello I m hoping someone can lead me in the right direction here I have a sql query that was written data Extract SQL to specific columns for me some time ago I need to have the data placed in specific columns and rows within the csv file Is it possible for me Extract SQL data to specific columns to do this Here is what I have below Lets say I need to place quot ASSRREAL Street quot in column D row of the csv file Any help or ideas would be great Thanks SET NOCOUNT ON SELECT quot RTRIM ASSRREAL Unique id quot AS Uniqueid quot RTRIM ASSRREAL Taxpayer quot AS Name quot quot As Name quot RTRIM ASSRREAL In Care Of quot AS Careof quot RTRIM ASSRREAL Street quot AS Address quot RTRIM ASSRREAL Street Mailing Addr quot AS Address quot RTRIM ASSRREAL City quot AS City quot RTRIM ASSRREAL State quot AS State quot RTRIM ASSRREAL Zip ASSRREAL Zip quot AS Zipcode ASSRREAL Acreage AS Acres quot RTRIM ASSRREAL Map Block Lot Xtr Mbl quot AS MBL quot CONVERT varchar ASSRREAL Volume quot AS Volume quot CONVERT varchar ASSRREAL Page quot AS Page quot RTRIM LTRIM ASSRREAL Prop Loc St No quot AS Street Number quot RTRIM ASSRREAL Prop Loc St Name quot AS Street Name quot RTRIM ASSRREAL Prop Loc Unit quot AS Street Unit FROM ASSRREAL WHERE ASSRREAL Delete Flag N AND ASSRREAL GSequence AND ASSRREAL Record Year ORDER BY ASSRREAL Prop Loc St Name ASSRREAL Prop Loc St No ASSRREAL Prop Loc Unit nbsp

Relevancy 57.62%


I have imported sales data in excel. The information lists in along two rows with mutliple columns. I need the information to be in one row under various headings. I have attached a link to a sample to explain this properly. I think I need to use a macro but I don't understand enough about them to make it work.

Any help would be much appreciated.

Relevancy 56.76%

I have music tracks CDs stored on a Windows machine that I use as a the How app to to tell rescan library? MUSIC home server I have mapped the folder where these are all stored as Z drive on my Windows bit tablet I tried using WMP as my music How to tell MUSIC app to rescan the library? library player but after days of scanning the collection the computer crashed because WMP had filled the C drive with album-cover artwork and STILL wasn't done scanning everything I read that the Win MUSIC the app formerly known as Zune I guess app 'handles large collections' so I told it to look at my mapped dive Z for music but it's not looking not finding anything NOTHING is showing in the library Opening Z in Exlorer I can see all the subfolders and the music therein but the MUSIC app is not bothering to look I've read that using a network share to store tracks for MUSIC requires that the folder with the tracks be mapped as a drive and that it be included in the Windows Search indexing schema As far as I can tell only Windows PRO allows indexing of network files and I just have standard Anyway- is there some command to tell the MUSIC app to RESCAN it's music storage locations

A:How to tell MUSIC app to rescan the library?

First of all: Using WMP for music collections is a bad Idea. It's ui is rubbish. But what's more it also messes up the media folders. It creats thounsands of cryptically named copies of the albums art files, it stores them hidden and marks them as system files and in some cases it even converts a ordinary folder.jpg file into a hidden system file. Get some decent media player like Winamp, Media Monkey or even VLC player.
Relevancy 56.76%

Hi right now I am currently on a laptop running Windows XP Professional. I have a computer running Windows XP Professional as well. What I would like to do is allow the laptop to access my music folder on the PC.
Is there any way to do this?
If you want you can IM me.

My aim is GiraffeGoWhack.

Thanks in advance.
Relevancy 56.76%

hello i have some short of a strange problem here. my wmp's library started o act strange many songs artists and album names suddenly were renamed after one artist well it's not a big thing tho it's anoying and confuses me. so i dont wrealy know if this is fault of wmp ore something else but i only use a media player for my music and movies. i checked for viruses ore mallware nothing was found. maybe anyone could help me with this issue?
Relevancy 56.76%

I in error set Iturnes as my default and it removed my husbands Music Library in Windows media player and now I cant find all of his music files that he downloaded.   How do I recover this library?
Relevancy 56.76%

Music library and mp player Hi I know that If you rip an original CD track to MP kbps and then for whatever reason decide to compress that MP even further - say to that would result in some loss of quality But Building a music library I am ripping everything on and downloading on too But then with my future mp player having music on format that doesn t allow to store a lot in the player So thought I could compress a bit more and the quality yes the quality will be lower but then you want good quality you don t use a mp player but a normal stereo Am I right or wrong But then the And Music Player Library Mp3 days of cd are counted so we still need to put music on digital format for the future so what quality audio to use Stay with mp Or go with some other format Music Library And Mp3 Player like apple or wma from window media player Or some new recent one but may be not compatible with my new mp player and meaning I have to re-rip all my audio again Then technology will be there and there will be no need of compression And then the web will be access from everywhere and we wont Music Library And Mp3 Player have our own computer but subscribing monthly to some web site to use and listen the music and for every thing else So I am getting so confused and lost my question is what you do today and what do you recommend And about the future how are you going to keep up thanks

A:Music Library And Mp3 Player

Here are my thoughts about this:No#1. Let today be today. If your music is .mp3, then keep it that way. Don't get tricked into the hype of what tomorrow may be like. You may not see tomorrow. Just keep doing as you're doing, and forget about the Jones'No#2. No one knows what tomorrow may bring, and since music isn't important as to being prepared for tomorrow, I wouldn't even think about it. If you need more room to store your files, then invest into another hard drive, and dedicate it to just your music.Your bitrate quality will really get disturbed if you went to a very low bitate, compared to it's original format/bitrate. And again, if your music sounds good to you, and you like it, leave it be. Don't go making projects out of things you really don't want to be wasting your time on. And yes, I know, the higher the bitrate, the larger the file size. It's your move now... so what are you going to do? I say just get more hard drive/storage space, and you'll nip it in the bud..wma formats, I always convert them to .mp3.Windows Media Player? If you're gonna use it (I see no reason why you would), just be aware that by default it is set to protect your music you rip using it. What that means is that your music is protected and it's virtually held hostage on your computer. Burning it from there won't work either. So, if you're going to use WMP, make sure you uncheck the Protect My Files checkbox. Even still, I'll never trust WMP with my music.Also, there is no reason to try to keep up with the ever growing of music softwares, just to listen to your music. If you use a program that plays your music, and it plays very well, then leave well enough alone. Alot of programs are designed to trick you, (like Windows Media Player), and they will DRM protect your music, and block you from transferring your music from your computer to disc, or where ever else you may want to put your music. Soon, you'll be posting here stating, your music all of a sudden doesn't play, you can't burn anything, your burner doesn't work, the programs you've used before all of a sudden don't work, you can play one file type, and not the other..... and the list goes on and on.Take this advice from someone that knows these computers and will inform you of what you should know about them. Trying to keep up with the Jones' and using the wrong softwares at the same time will get your computer slammed with problems.
Relevancy 56.76%

So, I don't really understand Xbox Music. After a clean install of Windows 8, I opened Xbox Music, clicked on My Music. It showed 106 albums, none of which are mine as far as I can tell. Later I added my music drive to the Music library, but it still shows the same 106 albums. I have over 22,000 songs; none of them show up in Xbox Music. Very confusing.

A:Xbox Music Library

Well, after about a half an hour it decided to update. Still seems like a mess. I can't tell sometimes which are songs on the Xbox Music Store and which are on my own hard drive. Seems like everything is just mixed together without any reason.
Relevancy 56.76%

I recently imported almost 3000 mp3 files into WMP and created a playlist with almost 500 songs. This took several hours to do. Now when I open WMP, it's empty! No playlist, no audio files anywhere. Anybody have any ideas?

A:WMP lost my music library!

Did you save the playlist. Logical thing to do if your making a large list. This happened to me a few times with Winzip with a Playlist of about 400 Songs. Luckily i saved my playlist after i add about 10 new songs to it.
Relevancy 56.76%

recently installed itunes and it decided to convert most of my library to aac, whatever that is. The problem is my music folder has pretty much doubled in size and is taking up 7gb when it should be about 4. is there any way to find and remove the duplicate files?

A:Music Library Nightmares

sorry, meant with some kind of program as too lazy to do it all manually
Relevancy 56.76%

So, my itunes library is almost perfected for my needs and includes all the music i want on my computer. however, when i go to my music folder from start, it's really disorganized and i can't stand it. i just want to know if there is a program or something that i can download that will organize my music, not just create another library and play it. the thing is, when i fixed my itunes library, i changed the artist, album, artwork etc. , but not on the original file. i want to keep all that junk too. basically, i just want it all organized. i'm really bad at describing my problem, sorry! anybody help! thanks!

A:Managing my music library, help!

Hey, if you bring up your iTunes and click on the advanced menu, then choose Consolidate Library, this will copy your files into your designated itunes folder under the directory artist/album. Also the files will be copied and not moved, so after you bring order to the chaos so to speak, you can delete your originals. And iTunes will recognise the change in directory so you wont have to re-add your library!
Relevancy 56.76%

This is driving me insane I am running WMP on Windows XP Home with Gb of Add Library all Will to WMP11 Not Music memory and an immense amount of free space on my hard drive in case that matters Originally all my music was displayed in the library with all the album art etc However I had WMP11 Will Not Add all Music to Library to re-install Windows and ever since then I have never been able to get WMP to add all the music to the library that was after all there before It adds some folder but not others yet they had all been added before my re-install I have tried the uninstal of WMP Windows Media Format Runtime and Microsoft User-Mode Driver Frameworks Feature Pack and deleted all Media Player Folders etc re-installed WMP and it STILL will not add the files as it did originally If I add the folders individually it will add the mp files to the library but I have hundreds of folders and adding them individually would take forever I have also followed all the suggestions for rebuilding the database again without success Does anyone know what I need to do to get WMP to once again add ALL my music to the library nbsp

Relevancy 56.76%

I m hoping there 2 3 columns compare EXCEL files data in is a formula within EXCEL that will allow me to complete this comparison I ve been working on it all day manually and realize it will take a long time to complete this way My computer is running on Windows Home Premium and my EXCEL is I have two different files and within each are three columns of data that I need to compare They re labeled NC NCI and SECNCI To be considered a match I need all three fields within a row to match exactly to a row within the other file The first file called REQUEST NET FILE has over rows of data so naturally there will be many repeats of these same three fields in that file but each row where the three fields match any row of data on the second file called DEPLOYED TABLE FILE needs to be the same to be considered a match If it doesn t match if possible I d also like to know why This could fall into two different scenarios NC CODE IS NOT ON DEPLOYED TABLE FILE or NCI SECNCI combo not on deployed table for this NC Once complete I ll run the same process in reverse so both files will end up with a match or no match next to each row If I need to run two separate compares one to EXCEL 2 files compare data in 3 columns get the match and then one on just the no match results to find the second bit of info I can do that Or if the second criteria can t be found via excel formula just the match no match result will be acceptable as that will save me so much time I was thinking a vlookup could do the compare for me but I m not good with vlookup formulas and after struggling a few hours with it I started searching and came across your site I ve found a few similar topics but nothing that I can translate into something for my specific need I ve attached portions of the two files and you can see on the REQUEST NET FILE where I ve managed to get to with doing it manually It s quite a tedious process so I m really hoping you can help Thank you Tech Support Guy System Info Utility version OS Version Microsoft Windows Home Premium Service Pack bit Processor Intel R Celeron R CPU GHz Intel Family Model Stepping Processor Count RAM Mb Graphics Card Mobile Intel R Series Express Chipset Family Mb Hard Drives C Total - MB Free - MB Motherboard Dell Inc G F Antivirus McAfee Anti-Virus and Anti-Spyware Updated and Enabled nbsp

Relevancy 56.76%

I have two columns of data. In column A, I need to identify every cell that is identical to any value in column B.

Relevancy 56.76%

Hi everyone

I'm a newbie here, so hoping someone can help me!!
I have Names and Mobile Number in Column A. I need to find a way of moving Mobile Numbers into Column B - please tell me there is a simple way in which this can be done.....HELP!

Relevancy 56.76%


First, thank you all for you time and knowledge in advance.

Here's my situation. I'm working with file that is sent to me with populated information, in this example Col A
What I would like to do is enter information in Col B and then do a comparison of both A and B, letting me know if something in Col B is not in Col A and also is something in Col A not in Col B.

I need to know if what was sent to my in the spread sheet match what I physically inventoried.

I have provided an example.

Hopefully I did not over complicate my request.

Thank you,


A:Solved: comparing data in two columns in Excel

does this help

or this may ble closer to what you need
Relevancy 56.76%

On the attached spreadsheet, I need a total count of baselined desktops (minus the ones that have been deleted) problem is how do I get it to look at one record, mark that that agent had been a baselined one, but is now deleted, so don't count it. I can't just remove the deleted ones, cause I want my customer to know which agents have disappeared. Take a look at the formula in B2 for a general idea. That formula doesn't work cause it just adds everything together. I need it to be smart enough to Total the Baselined Agents and then Subtract the agents that are baselined and deleted per field. Any questions let me know. Look at B2 to get an idea and see if I'm on the right track.

A:Solved: Excel - Trying to count 2 columns (almost as one) to get data for a 3rd.
Relevancy 56.76%

I have a very large spreadsheet (i.e. too big for pivoting and transposing wouldn't work) which looks something like this:
Col. ACol. BCol. CCol. DCol. ECol. FCol. GEntry1Info124562131654632435435Entry2Info150256874654242454654Entry3Info2221333333336546548463
I want it to look like this (i.e. flip Col.C through Col. G and line it up with Entry1, then do the same for Entry2, etc.):

Col. ACol. BCol. CEntry1Info12Entry1Info456Entry1Info2131Entry1Info6546Entry1Info32435435Entry2Info150Entry2Info25Entry2Info6874654Entry2Info242Entry2Info454654Entry3Info222Entry3Info133333Entry3Info333Entry3Info654654Entry3Info8463

Please help!

Relevancy 56.76%

Hi - I m semi-proficient with excel and I m actually working on creating some dashboard reports at this time One problem I m having is separating some of the data from a specific column Let me give you an example This column has over lines in Excel columns? separation Data Solved: this is just a sample What I need to do is break this column out by month and show how many dates are from the last month the last - months and the Solved: Data separation in Excel columns? ones that are months in the past Of course I want the sheet to show this info automatically so it has to know the current date which I can do by placing the formula quot TODAY Solved: Data separation in Excel columns? quot So what I m asking for is what formula and format would I use to count how many cells in this column fall into each of date ranges I mentioned Also I did manage to use the DAYS A C for example where A quot Today quot and C quot quot above This information is in cells next to the above data as follows - - - - - - - - - - - - - - - - So I figured out how to list how many days I have since the date Solved: Data separation in Excel columns? in the first column but not how to break them apart within the column Hopefully this is enough information to request some help but if you need more info please let me know I ll watch the thread closely Thank you -Drake nbsp

Relevancy 56.76%

I am having two column with current month profit & last month profit respectively Column A & Column B. I would like to compare both column & set the ICON (down Arrow & up Arrow ) based on result if A1 value greater than B1 set upper arrow else down arrow

A:How to set ICON in Excel by comparing data in 2 Columns

You didn't say where you wanted the arrows to appear, so I'll use C1 for this explanation.1 - In C1, enter this formula: =IF(A1>B1,2,IF(A1=B1,1,0))2 - Under the Conditional Formatting drop down, choose Icon Sets and then choose the Up arrow.3 - Go back into Conditional Formatting and choose Manage Rules4 - Edit the Rule for C1 as follows:----- Click the Show Icon Only box to place checkmark in box----- Change Type to be Number in both dropdowns----- Up Arrow: when value is >=2----- Sideways Arrow: when <2 and >0----- Down Arrow: when <=0 (should be default)5 - Click OKLet me know how that works for you.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Relevancy 56.76%

Hi A does anyone know how to search for the text content Searching Rows/Columns EXCEL Data in of a cell through a column and then return the value content of the cell of a certain other column of the same row where the text content was found e g A B C D T XY TP YZ TP ZY P YX TP YY FORMULA TP ZZ gt gt FORMULA EXCEL Searching Data in Rows/Columns quot Look for string TP in column A other than in EXCEL Searching Data in Rows/Columns row and return the value of that row in column C C YZ quot NOTE There might be more than row with the string TP in column A - I would need the sum of all results in column C where the FORMULA finds this string B I also have a similar problem with another worksheet It would require a formula which searches through a whole column for certain names e g quot Donna quot and then returns the value of another column in the same row where it found quot Donna quot the value again is not in a column directly EXCEL Searching Data in Rows/Columns adjacent to the column where quot Donna quot would be found This is fairly identical to problem A except that the search string would be unique only result and it doesn t have to take into account and disregard if the string was found in the same row of the FORMULA the search column would be in a different worksheet from the FORMULA worksheet Thanks for any suggestions Cheers from New Zealand Andreas nbsp

Relevancy 56.76%

I have a large excel file (3k= rows) of name/addr info. I want to transpose the date so information appears in its own column for sorting, etc. The problem is the data is not consistant. (sometimes there is two address enteries, sometimes three. In another record there may be two phone numbers. So each company may have six or seven rows of info. The only consistancy is that the company name is in bold. I've tried to attach a sample file so you can see what my task is. I'm not real good with Excel, so treat me like a dumy; it's OK.
I really appreciate the help.


A:Transposing column data into multiple columns

Bill, that was an awkward one, but I think this does what you want.
Just click on the "CommandButton1" and watch.
Relevancy 56.76%

I have data organised in paris of columns with differing amounts of data in each column pair.
I need to move all data to columns A&B:

- If there is data in columns C & D, move it to the foot of columns A&B.
- Then, if there is data in columns E & F, move it to the foot of columns A&B.
- Etc. til the end of the ActiveRange.

I've managed to do this using hard-coded column references, but it involves a lot of reptetition.
Presumably the code can be substantially compacted, and work to the end of the ActiveRange rather than to arbitrary end columns (in this case, cols AC and AD).

A:Solved: Excel VBA moving all data to columns A+B

This will work on the active sheet.... If you need this for multiple sheets we would need to alter the macro slightly. Test this on a copy of your xl file.


Sub appAB()

Dim i As Integer
Dim lRow As Integer
Dim lRowA As Integer

For i = 3 To 30 Step 2
lRow = Cells(Rows.Count, i).End(xlUp).Row
lRowA = Cells(Rows.Count, 1).End(xlUp).Row + 1
Range(Cells(1, i), Cells(lRow, i + 1)).Cut Destination:=Range("A" & lRowA)

End Sub
Relevancy 56.76%

I have a column that contains the full name of a client, eg. Mr B Cooney and I want to divide this into three columns (Title, Firstname and Surname). Can anyone help?

Relevancy 56.76%

I have data in columns - starting A Data columns Formulas Creating from in in rows - P and another set of data from A -P I have various formulae using that data starting in A -A I wish to include the second row of data the A -P into a second set of formulas from B -B Filling right doesn t work because if the formula in the A column is something as simple as quot A C D quot when I fill right the formula in the B column is quot B D E quot - when I NEED it to read quot A C D quot I realize there is probably a simple workaround for this - in fact I COULD just rekey the formula the reasons I don t are the formulas are more elaborate than I listed there will be many more rows of data at least more - Creating Formulas in rows from Data in columns so rekeying the formula for EACH row of data would be time-consuming and it will eventually move the formulas off the same visible area as the data I m currently combatting that by having the panes frozen Is there any way to accomplish what I m trying to get done Chris nbsp

Relevancy 56.76%

Hi all,

I am using the below formula (that I found on this forum) to calculate the age based on a DOB. I now want to create a formula for the next column to have either ‘Yes’ or ‘No’ if the age is above a certain value.

If this is possible, is it then possible if I have two ages in separate columns to generate a ‘Yes’ if either of the age’s are above the specified Value?

Formula for Age Calculation;
=DATEDIF($C24,NOW(),"y") & "y,"&DATEDIF($C24,NOW(),"ym") & "m,"& DATEDIF($C24,NOW(),"md") & "d"

Any help would be greatly appreciated,

Many thanks.

A:Data in columns formula to generate a new column

try this

=IF (Cell you do the calculation in > age you want to test , "Yes" , "No" )
if you want to test two columns , then

=IF ( OR(column1 > age, column2 > age ), "Yes", "No")

can you load a dummy spreadsheet and we can check the above works OK
Relevancy 56.76%

I have an excel sheet with 3 columns. What I want to do is, I need to be able to find value in column 3, that corresponds to a value in column 2. The value in column2 should match the value in col 1.


Input Data
Col1 Col2 Col3

The result should be
Col1 Col2 Col3
Please help me.

Relevancy 56.76%

Hi I have Worksheets I would like to compare the columns and add missing employees to Different Worksheets Columns Add Data on and Missing Compare the main worksheet and highlight any employees that no longer on the nd sheet Sample - Sheet Plant - PA's Column A Compare Columns on Different Worksheets and Add Missing Data Column B Column C Row Employee Name Employee ID Start Date Row Employee VLOOKUP Formula to Sheet VLOOKUP Formula to Sheet Row Employee Compare Columns on Different Worksheets and Add Missing Data VLOOKUP Formula to Sheet VLOOKUP Formula to Sheet Row Employee VLOOKUP Formula to Sheet VLOOKUP Formula to Sheet Row Employee VLOOKUP Formula to Sheet VLOOKUP Formula to Sheet Sample - Sheet Employee List Query Column Compare Columns on Different Worksheets and Add Missing Data A Column B Column C Row Employee Name Employee ID Start Date Row Employee Row Employee Row Employee Row Employee In the above example I would like to be able to add Employee from the Employee List Query to the bottom of the Plant - PA's sheet along with the VLOOKUP formulas in Columns B C I would also like to highlight Employee on the Plant - PA's as it has been removed form the Employee List Query sheet Hopefully this makes sense and is possible Thank you Sandi

A:Compare Columns on Different Worksheets and Add Missing Data

Hi,Here is an example of how i would do it, usually others will have a much cleaner and probably better way of coding the solution, however this is my way of doing it.Hopefully DerbyDad can provide a solution too.There are two method which you will need to call1) CopyMissingEmployeeThis will call IsOnOtherList and check if the employee exists on the other list, if not then the entire row is copied to sheet 12) HiglightRemovedThis will call IsMissing and will highlight any employees on sheet 1 where they do not appear on sheet 2.Hope this helpsPrivate Sub CopyMissingEmployee()

Dim URange, LRange
Dim BCell As Range
Dim NextRow

Set URange = Sheet2.Range("A2")
Set LRange = Sheet2.Range("A" & Rows.Count).End(xlUp)

For Each BCell In Sheet2.Range(URange, LRange)

If IsOnOtherList(BCell.Value) = False Then


NextRow = Sheet1.Range("A" & Rows.Count).End(xlUp).Row

Sheet1.Paste Sheet1.Range("A" & NextRow + 1)

End If

Next BCell

End Sub

Private Function IsOnOtherList(EmpID As String) As Boolean

Dim URange, LRange
Dim BCell As Range

Set URange = Sheet1.Range("A2")
Set LRange = Sheet1.Range("A" & Rows.Count).End(xlUp)

For Each BCell In Sheet1.Range(URange, LRange)

If BCell.Value = EmpID Then
IsOnOtherList = True
Exit For
IsOnOtherList = False
End If

Next BCell

End Function

Private Sub HiglightRemoved()

Dim URange, LRange
Dim BCell As Range
Dim NextRow

Set URange = Sheet1.Range("A2")
Set LRange = Sheet1.Range("A" & Rows.Count).End(xlUp)

For Each BCell In Sheet1.Range(URange, LRange)

If IsMissing(BCell.Value) = True Then

'BCell.EntireColumn.Interior.Color = vbYellow
BCell.EntireRow.Interior.Color = vbYellow

End If

Next BCell

End Sub

Private Function IsMissing(EmpID As String) As Boolean

Dim URange, LRange
Dim BCell As Range

Set URange = Sheet2.Range("A2")
Set LRange = Sheet2.Range("A" & Rows.Count).End(xlUp)

For Each BCell In Sheet2.Range(URange, LRange)

If BCell.Value <> EmpID Then
IsMissing = True
IsMissing = False
Exit For
End If

Next BCell

End Function
Relevancy 56.33%

I have my HD partitioned and I just put all my music into the "D:" Now, what I want to do is when I go to start and MY MUSIC, I want it to take me to the D:

By the way...I am using XP Home Ed.

Thanks in advance for any help

A:How do I change my music directory

You should make a new folder on your D drive and name it whatever you want. (ex. My Music) Then put you music in that folder as opposed to just leaving it on D: (the root) Then you can RIGHT click the folder and select "send to" and then "to Desktop as a shortcut" Then drag the new shortcut to the START button. Then when you click on My Music, it will go to that new folder with your music in it. That is one of about 1000 ways to do it. Play around a bit.
Relevancy 56.33%

I am trying to use the Xbox music application on my PC to be ablet o get access to my music on my windows phone.

Windows is run off of my SSD (C:\) and my music library is on one of my other drives (E:\). I have added the folder that contains my music to the Xbox app, but it still tells me that "Its Lonely" and I should add some music. I have also changed the "Music" folder to default to my E: drive
Relevancy 56.33%

I want a good program, that I can organize all my CD's (that are in mp3 format).

Relevancy 56.33%

Im having a problem with Windows 7 RC1. I have all my music on an external drive that i keep plugged into my computer. i added the music folder on my external to the music library in windows 7. whenever i open windows media player it always has to reload my music, which takes a few minutes. Im wondering if there is a way to make it not have to reload the music and just remember where it is.

A:Windows 7 not saving my music library

**** it im using iTunes
Relevancy 56.33%

My sister just bought one of these (Eposn P-2000 picture viewer and MP3 player).
I have an iPod and when I want to add songs I just connect to my computer and it launches iTunes.
My sister seems to think she can just add MP3's one at a time. She hasn't set up a music library. I told her when you have 100's of song files it makes sense to put them in a library like Windows Media PLayer or iTunes. I don't think the P-2000 supports iTunes. Does anybody know what it does work with, or is it it's own system, and you have to just add songs one at a time.
Thank you,
Paul aka Maui Cat
Relevancy 56.33%

Hi all I'm hoping someone can help me out with this one Got a new PC and I'm having some trouble with iTunes finding my music library Both machines were are running Windows XP well the old machine was running home edition new one is running Pro not that it probably matters and the latest version of iTunes I followed the steps on the Apple website for transferring the music and library http support apple com kb HT viewlocale en US the only difference being I used a portable HDD rather than my iPod I've gone to library music iTunes new Transferring PC through this process before a couple of times when I've had Transferring iTunes music library to new PC to format my hard drive for whatever reason and I've never had an issue until now I copied the iTunes folder over the the My Music folder like normal so the library files should all be correct Install iTunes and sure enough my library shows up just like normal Only problem is iTunes can't seem to locate the mp files themselves properly anymore Here's what I think is happening On my old PC the iTunes library files were stored in My Documents My Music like normal however due to lack of hard drive space I stored the actual mp files on a different hard drive in the machine in this case d mp This worked fine when I formatted that machine because iTunes was still pointed to the same hard drive for the music files as nothing changed on that hard drive when I formatted the primary drive with Windows on it In this case I've moved all the mp s to the default iTunes directory My Documents My Music iTunes iTunes Music since I don't have the hard drive space restraints I was dealing with before I confirmed that iTunes is pointing to the proper directory under Edit Preferences Advanced settings however every time I click on a song it's telling me it can't find the mp file and is asking me to locate it manually As far as I can see there's no way to do this easily without selecting one song at a time and locating the file for it I don't have the time or patience to go through my entire library and manually find all the files so is there an easier way to do this I was thinking if I delete my old library it may even be easier to re-add all the songs to a new one because at least that way I could select entire folders rather than one song at a time Any help you can provide is greatly appreciated Thanks

A:Transferring iTunes music library to new PC

Delete your iTunes Library.itl and iTunes Music Library.xml from the computer with the problem and then re-add the music. They are normally stored in the My Music\iTunes folder but I don't know where they would be stored on your machine. It sounds like you copied the library files over from the computer with all your music on the C drive so the new computer will look for the files on the C drive. The only way to stop this is to delete the library and have it re-find the songs.
Relevancy 56.33%

I got a ZUNE MP3 player as a gift and I installed the software to download music. Something I am wondering is if the ZUNE software installed in my PC takes control of all the music I have already stored. Some of this music I got as an-mail attachment and now since I got this ZUNE software it seems i can not use it anymore lets say to burn a cd. Can someone explain me why ? Is Zune always to be in control of my music library in Windows Media Player or other players like REAL ?

Thank you for your insights,

Relevancy 56.33%

Windows 8 metro Music app just does not display my music.

As you can see, my music folder is included in the music library:
but yet the Music app only recognizes two songs out of 1000+ that I own
Windows media player, the desktop app, is working fine.
I've tried to restart the metro app several times, in vain.
Relevancy 56.33%

I m looking for a way to catalogue all my music cds What I need is a program that will look up the album so I don t have to type anything be able to organize it and add the album art to my music folder I also want to be able to load my mp player a recent birthday gift from my music collection I m not interested in a radio function or purchasing music downloads Anyone have any suggestions besides Music Match Application Library for Need Music Recommendation which I presently use the basic version Music Match was recently purchased by Yahoo and from what I hear it s a real downgrade Also I prefer if it were free shareware Anyway any suggestions would be appreciated There is one player that I ve found but as I m not technical I don t understand half the bells and whistles If anyone would know if this would suit my situation you can read about it here - Need Recommendation for Music Library Application http downloads zdnet com download aspx docid Also what is winamp I know it has something to do with MP players but is it also a library If it has radio can I get am stations too I like talk radio but don t always have time to listen to it I would love to be able to upload programs to listen at my convenience Thanks for any info P S This is for my Laptop which has XP OS nbsp

Relevancy 56.33%

yea I am trying to make a list of my music library which is setup so that 1 folder=1 album so I am trying to take these 500 folders or whatever and somehow copy just the name of it to something like word, or excel or I can make a list of them to send to other people, print or whatever...I tried to copy and paste them to word, excel, wordpad, notepad, and I just tried to click and drag them to those programs but no luck...and yes I realize I could type them all out but that's a little too much like work... here's an example of how I have this all set up

A:Making a list of my music library help

From a command prompt go to the directory where all these folders exist.
Type: dir > list.txt
the list.txt file should have all the directory names for you. It'll also have couple of extra lines you might want to remove for current directory and parent directory.
Relevancy 56.33%

I am having a problem where no matter what I do, Windows Media Player 12 gives me a "there are no items in your music library"! there is no option to add anything anywhere! when I google the message, it tell me to go to "organize<manage libraries<music" the first 4 results in Google says to do that, the rest of Google is just spam.
the problem is when I go to organize<manage libraries<music, nothing happens! I need to sync music to my Sansa Fuse+ but cannot because of this problem! please help!
EDIT: I want to also mention that the "library" link/tab is grayed out in WMP12. deleting the appdata did not help! other than that Google full of spam

A:wmp12 "there are no items in your music library"

The "library" is not even a real's just a virtual location that doesn't have any content unless someone chooses to place "files" there by having them imported to that location.  In reality...all that happens (IMO) is that a pointer/shortcut is placed there which points to the real file location and allows it to be accessed/played.
I don't even use it on my Win 7 install, preferring to use other players (which do the same thing as WMP without all the unnecessary trash).
If WMP doesn't give you the option to "import" files into the library...try another player and sync your files with it.
To find the real locations of your music can use a tool like Everything Search Engine - and use the generic file extension (e.g. *.mp3) to find all .mp3 files.
Relevancy 56.33%

just want to listen to my music library without any commercials or issues

A:i want to listen to my library of music unempeded

Hi, you haven't mentioned what phone you are using or the OS.
On my Lumia 930 running Win10 mobile, I use the 'Groove Music' app, then go to 'Songs' and 'Shuffle all'.
This then plays my music library (without commercials or issues).
If you need additional help or have more questions or details to share, please join the site so you can reply in this thread. See this link for instructions on how to join Windows Central.
Relevancy 56.33%

My brother just downloaded a bunch of mp3s into my Music folder in my new laptop. I recently bought a 5.5 gen Video iPod and decided to include all these new songs in it. By dragging and dropping them into the iTunes library, they all went in.

That´s what I thought! When I saw the Library list, it was much shorter! I tried to manually drag-and-drop specific mp3s that hadn´t been copied onto the Library list. The ¨plus sign¨ icon indicating a file is being included showed up, but the file is not in there.

I have checked the properties in these files and they are the same as others in the Library, why are they not going thru?


Relevancy 56.33%

Hi, I recently did a check for registry errors after upgrading my hard disk and reinstalling Windows 7 and all of my programs. It found over 1000 which are now fixed.

However since doing this I can no longer access my libraries.
I am faced with, in both my Computer and in the start menu where the libraries should be, the name of the library followed by '.library-ms' as well as the blank page icon when you hover over them (please see the attached file).

Some how this file extension has disassociated itself from whatever program it is supposed to open with.

Does anyone know:

a: What program it needs to be associated with,
b: If it is possible to fix and
c: How to fix it.

Any and all help will be appreciated; thank you in advance for your help.


A:Libraries do not work. I just see music.library-ms.

Anyone? I need help with this.

Relevancy 56.33%

Not sure where this goes, but since I'm running a Windows XP machine...

I have "My Music" folders on three different machines. I want to merge them all as simply as possible into one single "My Music" folder. Most albums are in their own folders, but some are across multiple folders (thanks, iTunes).

I need something that'll take the contents of the three folders, merge them, and put all songs back into folders named for their albums (and under their artists' names).

Relevancy 56.33%

hey guys, i have recently been given a laptop, i removed vista and did a clean install of windows 7 ultimate. since then i have made a 30gb partition on the hard drive and have installed windows 8 as a dual boot. i would like to be able to use my music library from the music app within windows 8, is there any way to link the music to the partition so windows 8 can read it from windows 7? (i wasnt sure if this should be eight forums or seven, I have an account here so i decided here.)

thanksw in advance

A:Music library partition links?

If you use Windows Media Player in Windows 7, you can tell it to look for music in a certain location.
Organize-Manage Libraries-Music-Add, and then select the location where your music is.
Relevancy 56.33%

I deleted music files out of my Music folder in explorer...Then open windows media player and the music files were still there. I then tried to delete them from my media player and then get a warning that media player can not find files. and it will not give me an option to delete.....What to do next? I am running windows 7 and windows media player 12.0.7601.17514
Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Pentium(R) CPU P6200 @ 2.13GHz, Intel64 Family 6 Model 37 Stepping 5
Processor Count: 2
RAM: 3892 Mb
Graphics Card: Intel(R) HD Graphics, 1722 Mb
Hard Drives: C: Total - 183295 MB, Free - 135143 MB; D: Total - 273060 MB, Free - 272952 MB;
Motherboard: SAMSUNG ELECTRONICS CO., LTD., R530/R730/R540
Antivirus: AVG Internet Security 2012, Updated and Enabled

A:Corrupted library music files

Delete the WMP database and rebuild it:
Relevancy 56.33%

Just got my new HP dv us with Vista Home Premium Never tried media center before I have always been an iTunes fan when it comes to my music library about gigs worth Thought I d give the Media Center a try since I never Center music library Media and used it Media Center and music library before When viewing my music in the media center music library a lot of the album art is not displayed and a lot of my albums have some of their tracks split like they are part of separate albums I am assuming this has something to do with some of the tags maybe I use Mp tag to edit the tags on all my music then when importing to iTunes I use iTunes to edit some of the other least populat tags composers etc A lot of my album art I use iTunes to quot find quot the album artwork when importing When iTunes does this does it add the artwork to the tags or is it just for iTunes purposes which might explain some of the missing artwork on media center Also if I want to update or change my tags for any reason after media center has added it to it s library how can I get media center to quot update quot particular music and albums to reflect the changes OK to sum up What is the easiest way to get my missing album artwork to display in media center How can get my quot stray quot tracks back in their original albums so they won t show as a whole separate album How do I quot update quot my media center library if I make changes THANKS nbsp

A:Media Center and music library

One feature I like with WMP (Windows Media Player) and Windows Media Center is that they have the options to automatically search online and replace incorrect information with your songs, artists, etc. at the same time finding missing information (ie: album cover) however this feature has to be turned on. Go through your preferences and see if you would like this and then turn it on.
Relevancy 56.33%

Help anybody? My operating system is Windows 10 and I am using the latest iTunes version, 12.3.2; the problem I've encountered is that with some CDs, when I download them into iTunes and call up the downloaded file, only one or two of the tracks are shown in black whilst the rest are greyed out. This doesn't prevent the greyed out tracks being played in iTunes, but if I try and burn those tracks to make a compilation CD, they wont burn. There is no such problem with the tracks shown in black (on the same CD). I've tried re-downloading the CD, but it makes no difference. Any ideas how to resolve this problem gratefully received.
Relevancy 56.33%

OK I think I have a new problem.
I couldn’t add new music to my library and tried the direction on this site to move/delete WMP database files.
This works fine and I could then add more music …
problem solved but only temporariliy.
Once MP11 rebuilt my library, the problem returned.
So every time I want to add new music, I have to dump the old library database files and rebuild.
This is a problem as it takes three days to rebuild as I have a large music libary.
Any Ideas? Could it be because my library is too big?
Any advice is appreciated.


A:WMP11 - Music Library Problem

WMP is an OK media player, but the music database just doesn't work that well.

For a large music collection you should try MediaMonkey, a freeware all-in-one music organizer.
Relevancy 56.33%

No one has been able to describe this and trying to find a fix on the internet is proving to be impossible at least through Google Basically music to library randomly seems skip I m playing music and all of a sudden it stops I click the player and it s not responding for a few seconds and then goes to a new song If I happen to have it on top of all the other windows I see music library seems to skip randomly the media player cycling through a bunch of songs and music library seems to skip randomly then it starts playing one I say media player becuase I have tried WMP VLC Songbird and WinAmp but they all do the same thing edit I can go back and play through the song it just skipped through just fine So if Metallica - Enter Sandman skips and I go back to play the song it plays through just fine end edit This is completely random however I have noticed it tends to happen more after mins- hour of being asleep shut down a while Then it s even more random to the point where I may not even have the problem It seems to be doing it more often now though so I m getting worried more annoyed I thought maybe it was my hard drive cause it s happened a couple times while watching anime the video just stops and goes to the beginning This has only happened within the last weeks though So I switched to my library on an external hard drive but it still happens on there So then I tried installing songbird on my nd hard drive and playing it on there Maybe my main hard drive is going I was thinking Nope mins later it does it a couple of times music library seems to skip randomly I did build this computer in late July however it still happened on my old build So that s why I tested the hard drives since they are the only things that are the same It s also just the music I tested with a YouTube video playing and a video on my main hard drive Songbird at the time on the nd hard drive skipped but the audio was still playing on both the YouTube and VLC Anyone got any ideas At the moment I am testing a video on the nd hard drive as well as audio playing seeing if they both go out which would I think point to the nd hard drive But that seems odd that both my nd hard drive and external would do the same thing I also disabled enhancements as that seems to be a popular thing in search results Thanks for any and all help nbsp

A:music library seems to skip randomly

Enhancements disabled did not work.

I had a video on the 2nd hard drive playing as well as the audio. When it happened, both VLC and WMP failed. However, it finally logged an application error in the Event Viewer with this error for VLC (it force closed basically):

Faulting application name: vlc.exe, version:, time stamp: 0x4c76f9fe
Faulting module name: libmkv_plugin.dll, version:, time stamp: 0x4c76fa06
Exception code: 0x40000015
Fault offset: 0x000819f1
Faulting process id: 0x10a8
Faulting application start time: 0x01cb51608816eb05
Faulting application path: C:\Program Files (x86)\VideoLAN\VLC\vlc.exe
Faulting module path: C:\Program Files (x86)\VideoLAN\VLC\plugins\libmkv_plugin.dll
Report Id: 32b9ba7a-bd5a-11df-80dc-6cf049ec5d74

Google searching for the error code hasn't really given me anything useful...

Also I've noticed the last few times (can't recall before then) that my keyboard went unlit. It's a Razar Larycosa so it has back lights.
Relevancy 56.33%

I have a database which has about 60000 rows and 3 columns.
Here I have made a picture to show what exactly I want, this picture represent a general view of my data structure and also represent what I want.

I have 3 first columns (from left) and I want to create a new column like the last one which named New Text.
As you see I want to create a column which duplicate the Text of every row for X times. And X is the frequency of repeated number in Number ID 2.

For example: In Number ID 2, 8 repeated four times. So New Text should have four H. (H represent the text)

Please consider this to be done by Microsoft Access software, which I have no experience of working with.

A:How to create a new column using data of other columns in Microsoft Access

will take TWO updates.

1) a transaction to ADD Column "New Text"; commit

2) another to UPDATE "New Text" where "Number ID 2" equals "Number ID 1" value is TEXT;

(or something close to that - - it's be a while since I last used SQL grammar.
Relevancy 56.33%

We have a survey package which is great, but it out puts the questions numbers over the columns and each new row is a response, however our calculations are setup for the question numbers to be the rows and the responses are the columns. Is there any way to swap these values around in this fashion? Thanks for any help

A:Excel: swapping columns and rows layout of data?

Howdy. You can copy the data, then Paste Special > Transpose
Relevancy 56.33%

What would be the best way to find a specific Column Header, and copy the data found in the column until the column header is found again?

Relevancy 56.33%

Anybody ever encountered this situation or have any ideas?

One of our users has a multi-tab Excel (vers. 2002, SP3) workbook with several columns containing pricing and taxes on products we handle. When she prepares to print the worksheet, she hides some of the middle columns so that only the data in the first and last columns will print out. The issue is, as soon as she unhides the hidden columns, certain data fields get wiped out... deleted. Then, she has to retype them. There are no macros or VBA scripts programmed in this workbook, and no wierd formulas I've seen that would potentially do this. Is this possibly an Excel bug???

A:Hiding Columns Appear to delete data in hidden fields (?????)

Sounds like a user bug. I won't believe it's exactly as you describe without seeing the file.
Relevancy 56.33%

Hi This is a fab site just spent a good few hours reading through without realising the time ANyway I am stuck on an Excel problem I have two columns of which there are lots of duplicates in column A and various values in column B Like this A B Book Title Song One Book Title Song Two Book Title Song THree Book Title Song One Book TItle Song Two Book Title Song Three Book TItle Song Four and so on for rows Merge two Solved: a Data Columns from row Sort Excel and into What I would like to do is have all of the relevant info from column B in just one cell in one row rather than a separate row for each song title So what I ideally need is A B Book Title One Song One Song Two Song Three Book Title Two Song One Song Two Song Three Song Four and so Solved: Excel Sort and Merge Data from two Columns into a row on Solved: Excel Sort and Merge Data from two Columns into a row I have no idea where to begin with this I have read several similar Solved: Excel Sort and Merge Data from two Columns into a row things that might help but the problem is that each Book Title has a different number of songs in it Can any one advise a complete beginner on how I might accomplish this Many thanks for any guidance nbsp

Relevancy 55.47%

Hi all I have a spreadsheet that holds sports results based on age groups The age groups are in one column stored as U B U G U B U G U B U G which is the age B or G boy girl The results are in another column stored as whole numbers I am trying to find a formula that will allow me to sort on the first column in the order shown above and then on the second column in descending order and then bring back the other data like the name example Child A U B Child B U G Child C U B Child D U G Child E U G would be returned as U B Child C U G Child D U G Child B U G Child E U B Child A I know I can use a manual sort but I was hoping to automatically put the results in a separate sheet in the correct order Any ideas Thanks in advance nbsp

A:Excel - function to sort multiple columns of alphanumeric data

You could easily enter in this formula:
(where the three data columns are just A, B, and C) so that you get - instead of U6B, for instance - U06B. This allows you to sort correctly by age.
If you want it copied and sorted to another page like that, you really need a macro/VBA.
Relevancy 55.47%


I was hoping somone could please help me out.

I have an excel spread sheet with a lot of data in columns which i need to convert into rows. The problem is one column contains over 10,000 rows of data... thus making it too hard to transpose manually.

I have attached a copy of the spreadsheet (condensed version) and was hoping someone had some suggestions on how i can achieve my desired outcome.

Thanks very much,


A:Move alot of Data from Columns Excel 2010 - too big to transpose

I'm sorry to say that this is pretty much impossible as far as I can tell because there simply isn't enough consistency in your layout. If all rows were there and in order it would be easy enough.
As they aren't, one would need to inspect the titles to put them in the right place, but your titles don't always match either. For example your second "Telephone" entry is actually titled "Clinic Mobile", which the computer justly sees as very different indeed.
I'll try to help if I can, but you'll need some point of consistency if you want computers to automate a process. If it helps, here's a copy of my spreadsheet that inspects the titles (on sheet 2). If there are only a few problematic titles it might be easier to correct them manually (or use search and replace).
Relevancy 55.47%

Hi all,

I have an excel sheet attached as an example. What I want to do is
take the data in each column and put them together into one

In my attached excel sheet I would like to have the data in each
column look like this in one separate column each line for example 1-72-bk-1803

any help is appreciated....thanks

A:Excel question: how would you connect data in defferent columns into one column?

In E1 enter
copy down
Relevancy 55.47%

Hi guys I ve been going through this thread and its been a lot of help I Solved: data Checking seperate finding mismatches in columns and ve now come across a problem that i cant find the solution to and im hoping someone can help me out I have a file that contains two columns of data in MS Excel and one value in the first column corresponds to a value in the second column For example - Column Column A X A X B Y A X B Y What I have to do is find if there are any mismatches in the data for example an X corresponding to B instead of A or vice versa Solved: Checking data in seperate columns and finding mismatches or any other value instead of X and Y in the second column for that matter I would need a message saying there are a particular number of errors and the rows in error should be highlighted I DONT need the corrections just need to see where the mismatches are Im pretty new to Macros and VB so please bear with me but i do understand the basics and ive done some programming before Any help would be greatly appreciated Thanks nbsp

A:Solved: Checking data in seperate columns and finding mismatches

oops.. the X's and Y's are supposed to be in column 2.
That didnt quite show up how i expected it to..
Relevancy 55.47%

I am trying to build a spreadsheet that allows me to enter data (steel angle) by individual leg sizes and thicknesses that automatically references the correct weight per foot so I no longer have to look it up in a book. I have loaded the data and built the template, but I cannot get a formula to work that will search my array of data that has repeating data in all the columns, but where all the data in one row has a unique weight. I have tried several commands, and I feel like I need a nested command, but I do not have the knowledge to get it done properly. I have attached the file: Angle Database. Any help will be greatly appreciated.



A:Solved: Repeating Data in multiple columns for unique result

I used Concatenate and Vlookup to solve the problem. I just needed a week to let my head clear.
Relevancy 55.47%

I'm a novice excel VBA macro user. I've manipulated already created macros, but I'm not sure how to create one from scratch. Can someone please help me create a macro.

I'd like to move the values highlighted in yellow to the cells highlighted in green...and then delete any rows that are empty.

Thanks in advance for the help.

Relevancy 55.47%

..... and I want to convert the lot to 2 decimal place numbers.

Excel has several methods, but none seem to work for conversion in bulk. Working on futher cells from a suitably formatted one does not work.

Is the only way to solve my problem to manually enter the numbers elsewhere, clear the original cells, and then cut and paste back to the original cells?

Help please!

A:Number data in 10 columns and 25 rows pasted from other source is text

Need more info about the source text file. When opened in Word and Show All (the paragraph mark) is enabled, what does the text file look like?

See this thread from a couple years ago and see if it gives you any ideas:

Please Help - Data in Text File to be arranged in Excel in a specific

Relevancy 55.47%

Hi I amp m trying to work out how I can look at one column in a spreadsheet and display the text in another field but without a load of blank cells in the results column Let me give you an example On Sheet In column A are road names In column B the number of building on that to from multiple one data column 2010 Excel columns separating road In column C the last date and work was doneon the road In Column D is an IF formula thatbasically gives a result of Excel 2010 separating data from one column to multiple columns or On another sheet I want four lists Sheet In column A is a list of road names thathave a value of in Sheet column D In column B is a list of road names thathave a value of in Sheet column D In column C is a list of road names thathave a value of in Sheet column D In column D is a list of road names thathave a value of in Sheet column D I can do this with a simple IF statement in columns A B C amp D on sheet and drag it down but there are a couple of problems with this method If the value in sheet doesn amp t match I get a blank cell on sheet as there should be but this leaves a large number of cells with no value I need a list in each column A B C amp D onsheet without any blank cells I amp m going to be pasting different data into columns A B amp D on sheet a number of times and the number of rows in will be different each time I remember seeing something before thatinvolved using the IF and COUNTIF function in a formula but not sure how Any help would be appreciated nbsp

A:Excel 2010 separating data from one column to multiple columns

should be able to use an array formula - so use control + shift + enter key and the formula gets { } brackets


where you change the red =1
to =2, 3, 4 for different columns

does that work out

see attached

if it works we can extend the range and cleanup the errors
Relevancy 55.47%

I have all of my players set to stream media over the internet and locally When I first start up WMP and click on my office computer's library all of my music shows up I have around problem Music Strange with Library shared gigs of music I can play one song fine However when I click the Artist's tab again to get back Strange problem with shared Music Library to my music everything has changed to quot unknown artist quot and I cannot access my music If I refresh the library the only music that shows up are my artists that start with a or the letter a I have this same problem on my two computers that are locally shared on my network as well as my laptop which is sharing remotely Has anyone ever experienced this problem before If so is there a work around The reason I am using the shared library under other libraries instead of using each players internal library of the shared music library is because my Office computer where all of my music is stored has been edited to reflect all of the correct information artist album song genre etc I would rather not spend hours on each computers WMP editing all of this information to match my office computer's WMP I have also tried metadatabackup to try and make each player's data the same but it doesn't work on shared network players unfortunately Thanks Dan

A:Strange problem with shared Music Library

check this THREAD

feel free to ask
Relevancy 55.47%

I've noticed that the music library always shows folders (not files) first when ordering by date (created/modified). In Vista, files can be shown first, which I prefer since I can see my most recent music files. So my question is... is it possible to change this, to display files and then folders (as in Vista)?
Thanks in advance.

Update: it happens in all the libraries, not only in the music one. However in the computer explorer it doesn't, I mean, files appear in the first place.

A:display files before folders in the music library

Hello antoniomc, welcome to Seven Forums!

I haven't experimented with Libraries much so here's the link to the Libraries tutorials until someone can answer your question.

Tutorials - Windows 7 Forums
Relevancy 55.47%

Hi all,

Winamp's being... temperamental, to say the least.
I have a music library of ~2000 songs which I want to get it to sync to my MP3 player. It recognizes that my player is connected to my PC just fine, but when I tell it to sync all 2000 songs in one shot the program freezes and crashes.
I really do NOT want to have to sit at my PC for hours and sync my music library 50 songs at a time. Is there a workaround for this problem or am I just going to have to bite the bullet?



EDIT: Mods, please delete this thread, I reposted it in "Misc. Software". Thanks.
Relevancy 55.47%

Hello and thank you for reading,

I have a large digital music collection of about 5,000 songs. I just recently switched from a Windows Computer to a Mac. I transfered the files to the Mac and converted them to AAC - which promptly lost approximately 1,500 songs (I still have the Windows backups).

The library has become quite cumbersome to keep organized. iTunes does not provide an adequately easy interface to manage large amounts of somewhat unorganized files and I am looking for something more powerful.

A quick search online showed me several programs for Windows, but I wasn't able to find anything for Mac OS X. Does anybody have any suggestions for how I might organize this library?


A:Managing a large Digital Music Library

Go back to the PC?
Relevancy 55.47%


I'm having a small cosmetic issue with my library.

I'm attaching a snapshot that illustrates my issue the best way.

My Music folder has some field where it shoes C:\Users\Robert Norgren and that's what I'd like the hide. The section is not present for other libraries (Pictures/Videos/Documents).

Thanks! ( :

A:Library/My Music shows location path

Hello Robert,

I'm not sure of the language translation, but see if clicking on View (menu bar), Group by, and (none) will get rid of it for you.

Hope this helps,
Relevancy 55.47%

Hello Guys I'm having various problems with my Playlists on my computer with a recent fresh install of Windows pro I put all my albums into playlists and I use the playlists to select which music to play this is because I have lots of individual tracks etc everything works as it should do in desktop Windows Media Player When I open the Metro music app in Windows my playlist are all over the place App 8 Media Music Library frustrations! Windows sometimes there's too many sometimes too few Windows 8 Music App Media Library frustrations! sometimes they play and sometimes they don't some are duplicated and some are missing etc etc Windows 8 Music App Media Library frustrations! All my Music and playlists are stored in the My Music library as it default too I had about too many playlists and some were duplicated twice so tonight I bit the bullet and I deleted all the Playlists from Metro Music player I then imported my playlists using a right click there is now the correct amount of playlists but some are named incorrectly For example say I have a play list called Abba - Gold Music app now calls it Abba - Gold if I attempt to rename it to Abba - Gold it tells me quot That one's there already try a different name quot This only affects some playlists it seems as though the one's with a bracket and a number after the playlist with the same name already exist but it is not shown I also edited a playlist in WMP desktop tonight and I had to use the import playlist feature again to update the playlist in the Music app and now that playlist has a number next to it as well Does anyone know where the playlists for the music app are stored I'd like to find out and delete everything and start again I'm going from loving Windows to hating it because when I get to a stage where I'm happy with everything then something goes wrong or changes I've spent weeks solid trying to get everything to work as it should and I'm losing patience Thank for your help Tony

A:Windows 8 Music App Media Library frustrations!

This is not an audio problem (this forum section) but more a customization issue.

I'm using my Win 7 system right now and I see C:\Users\myname\Music as one location. Also C:\Users\Public\Music as another. Look in those locations.
Relevancy 55.47%

i none of my music will play in windows media player. my audio files are mp3 and wma.

anyone else have any problems like this???

the music will show up in my library but it wont play. it plays with winamp but not wmp

A:windows media player and my music library

Hi TwoTabs, welcome to the forums, install this codecs and will play almost anything. - Windows 8 Codecs - WMP12 Codecs
Relevancy 55.47%

In the default libraries there is a corresponding public folder of each library e.g. Documents/public documents, Pictures/public pictures etc...

But the only library showing the public folder is the music library. Why is this and how can I make it not show without removing the public music folder?


A:Music Library showing public folder as well?

underneath where it says music library (the title of the folder) it says 'includes 2 locations'. click that and then remove the public folder from there.
The public folder will still exist, it just wont be included in the music library.
Relevancy 55.47%

Alright iPod library download - Music Solved: I ve Solved: iPod - Music library download been putting this off for at least a month because I m dreading the whole process I ve got a GB mini and when I connect it to my computer an error message pops up I ve figured out that I have to restore my iPod and update it which will erase ALL the music from it Not so bad right Except for the fact that I have less than half of my songs on my computer To make the computer run more efficently I delete old songs that I don t listen to frequently The iPod runs fine but I can t upload any songs on it until I can fix the problem I ve heard of several different hacks to take music off an iPod but I need something free Any reccomentdations I tried doing one using WinAmp but it seems that WinAmp didn t download correctly and it wouldn t install I ll be happy to try again if that s the only way Thanks nbsp

A:Solved: iPod - Music library download

I've only just recently purchased my first iPod (a nano) and in crawling around the web I've managed to find a pretty good site for helping with my "iQuestions". Here's a link to an article on it for retrieving songs off an iPod, hope it helps some.